Arty,

       We have a similiar requirement, and we think the FILESPACE DB is the best
place to look.  Our backups are daily for all machines, so we can look
at the FILESPACE DB and spit out any FS's that haven't been backed up in
24 hours.  I don't know if your query works, but it is very similar to
what we are doing.


select node_name,filespace_name,backup_end from filespaces where
cast((current_timestamp-backup_end)seconds as decimal(18,0)) >=86400


       I am not an SQL expert so I had to experiment to get the time comparison
right, and am fairly confident it is doint what it is supposed to.

       One issue we have is Oracle Backtrack is not updating the FILESPACE DB,
so we aren't getting the Oracle 'filespaces' monitored.

scott


Arty Ecock wrote:

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

--
Scott Walters
Packet Pusher - "The world speaks IP"

Mack Trucks, WHQ        http://www.MackTrucks.com
2100 Mack Boulevard     Ph: 610.709.3728
Allentown, PA 18103     Fx: 610.709.2809