cancel
Showing results for 
Search instead for 
Did you mean: 

data size or backup size of a SQL policy in opscenter

rookie11
Moderator
Moderator
   VIP   

Hi experts,

symantec opscenter analytics. Version 7.5.0.1.

Q1) i need to customize a report which displays data size or backup size  of a SQL policy only full backup schedule.  please suggest how to configure it.

Q2) i need to customize a report which displays data size or backup size of an individual client. 

Q3) i need to customize a report which displays data size or backup size of a group of clients. They are not in a single policy. but need their data size for a week.

1 REPLY 1

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

A1, A2, A3) Try this (replace 'ora11g-01' and 'app-01' with your server names). the 1000 in 2nd last line is the amount of days to look back for the report.

Tested on my 7.6.0.1 env

 

select sum (domain_JobArchive.filesBackedUp) as "Files",
sum (domain_JobArchive.preSISSize)/1073741824 as "Protected GB",
domain_JobArchive.PolicyName as "Policy Name",
domain_Jobarchive.ClientName as "Client Name",
parentJobId as "Parent JobId",
DATEFORMAT(cast(UTCBigintToNOMTime(domain_JobArchive.endTime) as DATETIME), 'yyyy-mm-dd') as "Date"
from domain_JobArchive
where (domain_JobArchive.isValid = '1')
AND (domain_JobArchive.filesBackedUp NOT IN (0 ))
AND (domain_JobArchive.policyType IN (15 ))
AND (domain_JobArchive.type NOT IN (30, 31, 32, 33, 34 ))
AND  (domain_JobArchive.type IN (1, 0, 7, 6 ))
AND (domain_JobArchive.ClientName IN ('ora11g-01', 'app-01'))
AND DATEDIFF(day,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 1000
GROUP BY "Policy Name", "Client Name",  "Parent JobId", "Date" ORDER BY  "Parent JobId" ASC