[ADSM-L] SV: Select statement to output backup & archive summary per domain
2008-12-29 16:49:26
Hi,
Why not only run
q lic
q auditocc
?
Best Regards
Christian Svensson
Cell: +46-70-325 1577
E-mail: Christian.Svensson AT cristie DOT se
Skype: cristie.christian.svensson
________________________________________
Från: ADSM: Dist Stor Manager [ADSM-L AT VM.MARIST DOT EDU] för Joni Moyer
[joni.moyer AT HIGHMARK DOT COM]
Skickat: den 29 december 2008 21:13
Till: ADSM-L AT VM.MARIST DOT EDU
Ämne: Select statement to output backup & archive summary per domain
Hi Everyone,
I am trying to figure out how to configure a script that will output the
total GB backed up and total GB archived per domain within a 24 hour time
period. I already have something similar, but it totals all of the data
together and I would like to break it down more by the domain the server
belongs to.
Here are my current select statements.
select sum(cast(bytes/1024/1024/1024 as decimal(8,2))) "Total GB Backed
Up" from summary where start_time>=current_timestamp - 1 day and
activity='BACKUP'
select sum(cast(bytes/1024/1024/1024 as decimal(8,2))) "Total GB Archived"
from summary where start_time>=current_timestamp - 1 day and
activity='ARCHIVE'
Does anyone have any suggestions? I would really appreciate the help.
Thanks in advance!
********************************
Joni Moyer
Highmark
Storage Systems, Storage Mngt Analyst III
Phone Number: (717)302-9966
Fax: (717) 302-9826
joni.moyer AT highmark DOT com
********************************
|
|
|