jayjay00
9 years agoLevel 3
Opscenter/netbackup - SQL query to have a weekly report: Policy with start Time and End Time
Hello,
The goal is to have a gantt diagramm (made with excel) for the last week that show for each policy the start time and the end time.
I found some report on opscenter to have this kind of ...
- 9 years ago
Try this
SELECT
domain_JobArchive.policyname as "Policy",
domain_JobArchive.statuscode as "Status",
UTCBigIntToNomTime(domain_JobArchive.startTime) as 'Start Time',
UTCBigIntToNomTime(domain_JobArchive.endTime) as 'End Time'
FROM
domain_jobarchive
WHERE
domain_JobArchive.type in (0) AND (domain_JobArchive.parentjobid = domain_JobArchive.id)
ORDER BY
'Start Time'