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:[EMAIL PROTECTED] On Behalf Of Warren, Matthew (Retail) Sent: Wednesday, October 13, 2004 5:34 PM To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] On Behalf Of Hans Christian Riksheim Sent: Wednesday, October 13, 2004 12:49 PM To: [EMAIL PROTECTED] 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
