Yes, that is possible. Wrapping perl around a lot of TSM-queries has
been my method of choice until recently. But then I heard about TSM
Console and used that since. I really recommend it. Takes about two
minutes to set up and you have it running with a default report. Fully
customizable with your own specialized SQl-queries, alarms etc. Set it
to mail the report automatically to the TSM-administrators and local
client administrators can be automatically notifed when the client
schedule has 'missed' or 'failed'. 

Use another 10 minutes to set up Apache and these reports are available
on the web. 

Usually I am sceptical about these products and prefer the
script/hack-method, but TSM Console is great.

It's free. Try downloading it from IBM(search for TSM Operational
Reporting)


Best regards

Hans Chr.




 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Warren, Matthew (Retail)
Sent: Wednesday, October 13, 2004 5:34 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Equivalent of UNIX "tail/head" in TSM SQL query

A moot point from me, as Richard has settled the DB type question but,

You should still be able to execute system 'dsmadmc' commands and
collect the output into perl? IE, using the backticks notation or
system() or something similar to just do 

@output=`dsmadmc -id= -pa= select stuff from the_db where thingummies
are interesting`

or similar....

no?



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Hans Christian Riksheim
Sent: Wednesday, October 13, 2004 12:49 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Equivalent of UNIX "tail/head" in TSM SQL query

 

> Install Perl on your (I assume) Windows machine and imbed your select
statement within a Perl script that does what you > > want.
> 
> Welcome to an operating system that doesn't come with anything
resembling a decent scripting language.


Usually Perl is what I use on all platforms, but in this case it is not
possible. This because the SQL is made within TSM Console which gives no
such options.


Best regards

Hans Chr. Riksheim 


___________________________ Disclaimer Notice __________________________
This message and any attachments are confidential and should only be
read by those to whom they are addressed. If you are not the intended
recipient, please contact us, delete the message from your computer and
destroy any copies. Any distribution or copying without our prior
permission is prohibited.

Internet communications are not always secure and therefore Powergen
Retail Limited does not accept legal responsibility for this message.
The recipient is responsible for verifying its authenticity before
acting on the contents. Any views or opinions presented are solely those
of the author and do not necessarily represent those of Powergen Retail
Limited. 

Registered addresses:

Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry,
CV4 8LG.
Registered in England and Wales No: 3407430

Telephone +44 (0) 2476 42 4000
Fax +44 (0) 2476 42 5432