Video Screencast Help

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,
 
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?
 

 

Discussion Filed Under: