Hallo Yann, yes, you are right, the OC 7.1 is free and it has a nice dashboard but as James mentioned, it is not really that slick at the moment for the required purpose.
Please correct me if I'm wrong, but as far as I understand from my tests, currently the Operation Center does not support a regular reporting (e.g. execute select statements and as a result build an output report data file (potentially html) and e-mail it at regular times). With the OC you currently can send TSM message alerts to e-mail recipients after enable ling with "SET ALERTEMAIL on" , setting the e-mail definitions and then specifying the TSM messages to be alerted and sent via e-mail (e.g. Define Altertrigger ANR1234E,ANR5678E Admin=john,mikel). The OC will for sure improve further in future, but reporting so far will be left to the additional product package "Tivoli Monitoring for Tivoli Storage Manager Version 6.3.4" which can be downloaded from IBM/TSM FTP site But also true is: Many roads lead to Rome and one of them is also using the old TSM MMC with two changed XML files which works fine also for TSM 6.3.4 (7.1 I've not tested) Rdgs michael -----Ursprüngliche Nachricht----- Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von Meunier, Yann Gesendet: Donnerstag, 6. Februar 2014 10:21 An: ADSM-L@VM.MARIST.EDU Betreff: Re: AW: TSM REPORTING and EMAILS Hi, You can use TSM Operation Center 7.1 too. It's free ! Best regards, Yann MEUNIER Ingénierie - Système Stockage Informatique CDC - Etablissement DPI Office : +33 1 58 50 53 01 Mobile : +33 6 62 47 88 56 -----Message d'origine----- De : ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] De la part de Michael malitz Envoyé : jeudi 6 février 2014 08:53 À : ADSM-L@VM.MARIST.EDU Objet : [ADSM-L] AW: TSM REPORTING and EMAILS 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. Ce message et toutes les pièces jointes (ci-après le « message ») sont confidentiels et établis à l’intention exclusive de ses destinataires. Toute utilisation de ce message non conforme à sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. Si vous recevez ce message par erreur, merci de le détruire sans en conserver de copie et d’en avertir immédiatement l’expéditeur. Internet ne permettant pas de garantir l’intégrité de ce message, la Caisse des Dépôts et Consignations décline toute responsabilité au titre de ce message s’il a été modifié, altéré, déformé ou falsifié. Par ailleurs et malgré toutes les précautions prises pour éviter la présence de virus dans nos envois, nous vous recommandons de prendre, de votre côté, les mesures permettant d'assurer la non-introduction de virus dans votre système informatique. This email message and any attachments (“the email”) are confidential and intended only for the recipient(s) indicated. If you are not an intented recipient, please be advised that any use, dissemination, forwarding or copying of this email whatsoever is prohibited without Caisse des Depots et Consignations's prior written consent. If you have received this email in error, please delete it without saving a copy and notify the sender immediately. Internet emails are not necessarily secured, and declines responsibility for any changes that may have been made to this email after it was sent. While we take all reasonable precautions to ensure that viruses are not transmitted via emails, we recommend that you take your own measures to prevent viruses from entering your computer system.
