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()))
