Hello, The list of activities (SUMMARY.ACTIVITY) seems to be: 'TAPE MOUNT' 'FULL_DBBACKUP' 'INCR_DBBACKUP' 'EXPIRATION' 'RECLAMATION' 'MIGRATION' 'MOVE DATA' 'STGPOOL BACKUP' 'BACKUP' 'RESTORE' 'ARCHIVE' 'RETRIEVE'
You can include those you want. You can also combine with the field SUMMARY.SUCCESSFUL which is 'YES' or 'NO'. Regards Christian Bagard SOS-Restore - 32 cours Mirabeau - 13100 Aix-en-Provence - France ----- Original Message ----- From: "Joni Moyer" <[EMAIL PROTECTED]> To: <ADSM-L@VM.MARIST.EDU> Sent: Wednesday, January 26, 2005 2:56 PM Subject: Admin Job Summary > Hello everyone! > > I am trying to do a script to find out if all admin jobs were successful or > not, the summary of the info. and the time at which the task ended. I > found a script to run to find the total amount of data backed up with > storage pools, but I was wondering if there is any way to just pull the > summary info. from the activity log or is there a different way to query > the summary table so that I can see stgpool backups, migrations, dbbackups > and reclamation summaries? Thanks in advance! > > select entity as "Storage Pool ", cast(sum(bytes/1024/1024/1024) as > decimal(10,3)) as "Total GB", ' ' as " ", substr(cast(min(start_time) as > char(26)),1,19) as "Start Date/Time", substr(cast(max(end_time) as > char(26)),1,19) as "End Date/Time" from summary where > start_time>=current_timestamp - 24 hours and activity='STGPOOL BACKUP' > group by entity > ******************************** > Joni Moyer > Highmark > Storage Systems > Work:(717)302-6603 > Fax:(717)302-5974 > [EMAIL PROTECTED] > ******************************** >
