09-25-2014 09:00 AM
symantec opscenter analytics. Version 126.96.36.199.
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.
09-25-2014 11:04 AM
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 188.8.131.52 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"
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