Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Opscenter analytics - bad info of job type duplication

Created: 11 Jul 2013
tocals's picture

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,
dj.type = 4 AND
dj.startTime >= UTCTimeToUTCBigInt('2013-05-16') AND
dj.startTime <= UTCTimeToUTCBigInt('2013-06-16')
Is the domain_jobarchive table the correct place to get this information?
Discussion Filed Under: