Daily backup report using symantec netbackup opscenter analytic

Uploaded.

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()) <= 1

2.

SELECT *
FROM domain_JobArchive
WHERE domain_JobArchive.Type in (0)
AND domain_JobArchive.StatusCode in (0)
AND DATEDIFF(day,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 1

3.

SELECT *
FROM domain_JobArchive
WHERE domain_JobArchive.Type in (0)
AND domain_JobArchive.StatusCode in (1)
AND DATEDIFF(day,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 1

4.

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()) <= 1

5.

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