cancel
Showing results for 
Search instead for 
Did you mean: 

Failed Job Report

smakovits
Level 6

I am using this custom query to show failed jobs, However for our vm policies, it only shows the media server that is backing up the vm client.

Here is the query:

SELECT domain_MasterServer.friendlyName as "MasterServer", domain_JobArchive.policyName as "Policy", domain_JobArchive.clientName as "Client"
FROM domain_JobArchive, domain_MasterServer
WHERE domain_JobArchive.masterServerId = domain_MasterServer.id
    AND domain_JobArchive.isValid = 1 AND domain_JobArchive.type = 0 AND domain_JobArchive.statusCode not in (0, 1)
    AND domain_JobArchive.endTime > NOMTIMETOUTCBIGINT(DATEADD(hour, -24, getdate()))
EXCEPT
SELECT domain_MasterServer.friendlyName as "MasterServer", domain_JobArchive.policyName as "Policy", domain_JobArchive.clientName as "Client"
FROM domain_JobArchive, domain_MasterServer
WHERE domain_JobArchive.masterServerId = domain_MasterServer.id
    AND domain_JobArchive.isValid = 1 AND domain_JobArchive.type = 0 AND domain_JobArchive.statusCode in (0, 1)
    AND domain_JobArchive.endTime > NOMTIMETOUTCBIGINT(DATEADD(hour, -24, getdate()))
 
 
 

 

0 REPLIES 0