cancel
Showing results for 
Search instead for 
Did you mean: 

Opscenter analytics - bad info of job type duplication

tocals
Level 4
Partner Accredited Certified

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?
 

 

0 REPLIES 0