Daily backup report using symantec netbackup opscenter analytic
- 10 years ago
Uploaded.
- 10 years ago
For 2,3,4 below I've selected * (which means all columns). You can modify that to only select the columns you want by replacing the * with column names. Example
--------
Select
domain_jobarchive.PolicyName,
domain_jobarchive.PolicyType,
domain_jobarchive.ScheduleName,
domain_jobarchive.StatusCode,
domain_jobarchive.Throughput,
domain_jobarchive.BytesWrtiten
FROM domain_jobarchive
--------
1.
SELECT COUNT(*) as "Number of Backup Jobs"
FROM domain_JobArchive
WHERE domain_JobArchive.Type in (0)
AND DATEDIFF(day,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 12.
SELECT *
FROM domain_JobArchive
WHERE domain_JobArchive.Type in (0)
AND domain_JobArchive.StatusCode in (0)
AND DATEDIFF(day,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 13.
SELECT *
FROM domain_JobArchive
WHERE domain_JobArchive.Type in (0)
AND domain_JobArchive.StatusCode in (1)
AND DATEDIFF(day,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 14.
SELECT *
FROM domain_JobArchive
WHERE domain_JobArchive.Type in (0)
AND domain_JobArchive.StatusCode NOT in (0,1)
AND DATEDIFF(day,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 15.
SELECT COALESCE(CAST(SUM(domain_JobArchive.preSISSize)/1024.0/1024.0/1024.0 AS NUMERIC (20,2)), 0) AS 'Backed Up (GB)'
FROM domain_JobArchive
WHERE domain_JobArchive.Type in (0)
AND DATEDIFF(day,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 1