If you have a Unix/Linux box around, no problem. If you're stuck with Windows, Activestate Perl is free as is, of course, Powershell. There are Perl modules for email, but blat (http://www.blat.net/) works just as well.
Steve STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | [email protected] | icfi.com ICF INTERNATIONAL | 7125 Thomas Edison Dr, Suite 100, Columbia, Md 21046 | 443-718-4900 (o) > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf > Of Lepre, James > Sent: Wednesday, February 05, 2014 1:35 PM > To: [email protected] > Subject: Re: [ADSM-L] TSM REPORTING and EMAILS > > From: Lepre, James > Sent: Wednesday, February 05, 2014 1:31 PM > To: [email protected] > 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.
