Results 1 to 1 of 1
Thread: VMDK backup/restore query script
02-11-2011, 07:26 AM #1
- Join Date
- Mar 2010
- Greater London, UK
- Thanked 0 Times in 0 Posts
VMDK backup/restore query script
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:
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'
By micha in forum TDP/Application Layer BackupReplies: 0Last Post: 07-13-2009, 09:36 AM
By xiewadu in forum Backup / Archive DiscussionReplies: 1Last Post: 05-12-2008, 02:35 PM
By jbagley in forum ScriptingReplies: 1Last Post: 11-02-2006, 08:13 AM
By kim_mitchell in forum ScriptingReplies: 6Last Post: 12-01-2004, 02:14 PM
By francv in forum Backup / Archive DiscussionReplies: 0Last Post: 02-09-2004, 08:48 AM