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.
