Yes Arty,

I have the same problem, i solved it wit a select macro scripts, i bind
toether in one executable file,

I have a example of the output attacment, in a file called log.txt

I alsow am workin on a new version, where i will show when the backup
compleded, and how the sessions where.

If anyone wants to have it, your more than welcome to contact me and i can
give it you yah,

Kvedja/Regards
Petur Eythorsson
Taeknimadur/Technician
IBM Certified Specialist - AIX
Tivoli Storage Manager Certified Professional
Microsoft Certified System Engineer

peddi AT itn DOT is

 Nyherji Hf              Simi TEL: +354-569-7700
 Borgartun 37            105 Iceland
 URL:                    http://www.nyherji.is


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Arty Ecock
Sent: 16. september 2002 13:30
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Backup reporting


Hi,

   We're trying to put together some TSM backup reports for our
Help Desk staff.  We're using something like

   SELECT * FROM EVENTS ...

and things like

   SELECT NODE_NAME, LASTACC_TIME FROM NODES

and

   SELECT NODE_NAME, FILESPACE_NAME, (CURRENT_TIMESTAMP-BACKUP_END) DAYS
   AS "Days_Since_Backup" FROM FILESPACES WHERE
   CAST((CURRENT_TIMESTAMP-BACKUP_END) DAYS AS DECIMAL) >= 30 ORDER BY
   "Days_Since_Backup"

   What we need is a single, consolidated report that lists all our
client nodes and the (real) status of the morning's backup run.
"Query Events" (and the Select * from Events ...) will tell us
if the scheduled backup was "Completed", "Missed", or "Failed".
>>From our experience, "Completed" only means that the scheduled
command actually completed, not that it was truly successful.
By way of exmple, we use a scheduled command script to drive our
Domino TDP backups.  The script invokes the DOMDSMC command to
actually perform the backup.  DOMDSMC may fail miserably, but as
long as the invoking (scheduled) script completes, the status of
the backup shows "Complete".  (We now pass a bad RC from the script
if DOMDSMC returns a bad RC).

   For our Oracle TDP backups, I believe there is a way to issue
a SELECT against the Oracle (RMAN?) instance to determine the state
of the most recent backup.

   Our Help Desk needs to determine if a backup for a given node
actually completed successfully, and if it failed, they need to
determine the cause (all without having exceptional knowledge of
TSM).

   I'm sure this problem has been addressed by many sites in many
ways.  Our ideal solution would be a number of SELECTs, which we
could drop in a CGI script on some Web Server.

   Any words of advice?

Arty Ecock
CUNY/CIS - (212) 541-0956

log.txt
Description: Text document