Hallo James, one alternative would be to use / test the FREEWARE version of the "Power Administrator for TSM". (www.tsmpoweradmin.com)
There we allow one set of reports similar to the "old" legacy "Operational Reporting" which was "officially" available with the MMC (Microsoft Management Console) until TSM version 5.5. You can modify our version of the "TSM Operational Reporting" and can add your select statement(s) as an additional report within the report package, schedule the execution and e-mail the output to you at regular times. If you need further information pls feel free to send me an-email Rgds Michael michael.mal...@tsmpoweradmin.com p.s. in the professional version we have of course a lot more out-of-the-box reports. If you want you can use the prof version 45 days and than switch to the freeware one, just install on top of the prof one, that's it.. -----Ursprüngliche Nachricht----- Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von Lepre, James Gesendet: Mittwoch, 5. Februar 2014 19:35 An: ADSM-L@VM.MARIST.EDU Betreff: Re: TSM REPORTING and EMAILS From: Lepre, James Sent: Wednesday, February 05, 2014 1:31 PM To: ADSM-L@VM.MARIST.EDU Subject: TSM REPORTING and EMAILS Hello Everyone - I recently upgraded to version 7.1 of TSM. However, I have lost some functionality in the process. I used to send from the Tivoli Management Console an email to myself showing all that the backups completed, missed or failed. I can no longer do this with version 7.1. I do not want to setup monitoring in the OC because that is not really that slick. Is there away I can use the command I am using from the tivoli command line, write a script and schedule the sending of the email Here is the commands I am using SELECT entity AS "Node name", CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS "MB xfer", SUBSTR (CAST(min (start_time) AS char(29)),1,10) AS "start date", SUBSTR (CAST(min (start_time) AS char(29)),12,8) AS "start time", SUBSTR (CAST(max (end_time) AS char(29)),1,10) AS "end date", SUBSTR (CAST(max (end_time) AS char(29)),12,8) AS "end time" FROM summary WHERE activity='BACKUP' AND start_time>=current_timestamp - 24 hours GROUP BY entity q event * * begind=today-1 endd=today endt=05:00:00 f=s Any Help would greatly be appreciated Thank you James --------------------------------------------------------------- Confidentiality Notice: The information in this e-mail and any attachments thereto is intended for the named recipient(s) only. This e-mail, including any attachments, may contain information that is privileged and confidential and subject to legal restrictions and penalties regarding its unauthorized disclosure or other use. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action or inaction in reliance on the contents of this e-mail and any of its attachments is STRICTLY PROHIBITED. If you have received this e-mail in error, please immediately notify the sender via return e-mail; delete this e-mail and all attachments from your e-mail system and your computer system and network; and destroy any paper copies you may have in your possession. Thank you for your cooperation.