Hi all,

I currently have a script on TSM that a colleague of mine has written a script for checking the success/failure of our VMDK backups and restores, the only issue with this script is that it doesn not report the actual names of the servers, there are different servers backed up on different days, I was wondering if possible someone could look at this script and see if there is a way for it to output the server names as well as what it already reports.

Here's the script:
Code:
select count(*) as BACKUP_VMDK from summary where entity='SUESX_VMDK' and activity='BACKUP' and date(start_time)='$1' and SUCCESSFUL='YES' 
select count(*) as RESTORE_VMDK from summary where entity='SUESX_VMDK' and activity='RESTORE' and date(start_time)='$1' and SUCCESSFUL='YES' 
select date(start_time) str_date, time(start_time) str_time, date(end_time) as end_time, time(end_time) end_time, activity, successful from summary where entity='SUESX_VMDK'  and (activity='BACKUP' or activity='RESTORE') and date(start_time)='$1'
Any and all feedback is appreciated.
Thanks.

CX