Hello All
I'm creating some queries to make assessment reports and I'm noticing that all duplicate jobs are with bytes written and files backedup return zero.
Below a query example
SELECT * from
vxpmdb.DBA.domain_JobArchive dj,
WHERE
dj.type = 4 AND
dj.startTime >= UTCTimeToUTCBigInt('2013-05-16') AND
dj.startTime <= UTCTimeToUTCBigInt('2013-06-16')
ORDER BY
dj.startTime
Is the domain_jobarchive table the correct place to get this information?