OpsCenter common custom reports

Opscenter version - 8.1.1

Affected master server version - 7.6.1.2

Hello all,

I had configured canned report to generate all failed backups. However, It was brought to my attention, the report is skipping or failing to report error codes 196. I took a look, I discovered this is indeed happening. Has any one encountered this issue and how it was resolved?

Here's the show query report :

select TOP 100 START AT 1 domain_MasterServer.id as "domain_MasterServer.id",domain_Client.id as "domain_Client.id",domain_Policy.name as "domain_Policy.name",domain_JobArchive.statusCode as "domain_JobArchive.statusCode",(case when domain_JobArchive.state =106 then 3 when domain_JobArchive.state =3 and domain_JobArchive.statusCode =0 then 0 when domain_JobArchive.state =3 and domain_JobArchive.statusCode =1 then 1 when domain_JobArchive.state =3 and domain_JobArchive.statusCode>1 then 2 else -1 end) as "jobExitStatus",adjust_timestamp(domain_JobArchive.startTime,-14400000 ) as "domain_JobArchive.startTime",adjust_timestamp(domain_JobArchive.endTime,-14400000 ) as "domain_JobArchive.endTime",NOM_DateDiff(domain_JobArchive.startTime, domain_JobArchive.endTime) as "backupJobDuration",nb_JobFilesArchive.fileinfo as "nb_JobFilesArchive.fileinfo",domain_JobArchive.state as "domain_JobArchive.state",nb_JobBackupAttributesArchive.destStorageUnit as "nb_JobBackupAttributesArchive.destStorageUnit" from domain_JobArchive , domain_MasterServer , domain_Client , domain_Policy , nb_JobFilesArchive , nb_JobBackupAttributesArchive , nb_JobArchive where domain_MasterServer.id = domain_JobArchive.masterServerId and domain_MasterServer.id = domain_Client.masterServerId and domain_MasterServer.id = domain_Policy.masterServerId and domain_MasterServer.id = domain_JobArchive.masterServerId AND domain_JobArchive.masterServerId = nb_JobFilesArchive.masterserverId and domain_JobArchive.clientName = nb_JobFilesArchive.clientName and domain_JobArchive.id = nb_JobFilesArchive.jobId and domain_MasterServer.id = domain_JobArchive.masterServerId AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId and domain_JobArchive.clientName = nb_JobArchive.clientName and domain_JobArchive.id = nb_JobArchive.id AND nb_JobArchive.masterServerId = nb_JobBackupAttributesArchive.masterserverId and nb_JobArchive.clientName = nb_JobBackupAttributesArchive.clientName and nb_JobArchive.id = nb_JobBackupAttributesArchive.jobId and domain_Client.masterServerId = domain_JobArchive.masterServerId and domain_Client.name = domain_JobArchive.clientName and domain_Client.masterServerId = domain_JobArchive.masterServerId and domain_Client.name = domain_JobArchive.clientName AND domain_Policy.masterServerId = domain_JobArchive.masterServerId and domain_Policy.name = domain_JobArchive.policyName and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName and domain_Policy.versionNo = domain_JobArchive.policyVersionNo and domain_Client.masterServerId = domain_JobArchive.masterServerId and domain_Client.name = domain_JobArchive.clientName AND domain_JobArchive.masterServerId = nb_JobFilesArchive.masterserverId and domain_JobArchive.clientName = nb_JobFilesArchive.clientName and domain_JobArchive.id = nb_JobFilesArchive.jobId and domain_Client.masterServerId = domain_JobArchive.masterServerId and domain_Client.name = domain_JobArchive.clientName AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId and domain_JobArchive.clientName = nb_JobArchive.clientName and domain_JobArchive.id = nb_JobArchive.id AND nb_JobArchive.masterServerId = nb_JobBackupAttributesArchive.masterserverId and nb_JobArchive.clientName = nb_JobBackupAttributesArchive.clientName and nb_JobArchive.id = nb_JobBackupAttributesArchive.jobId and domain_Policy.masterServerId = domain_JobArchive.masterServerId and domain_Policy.name = domain_JobArchive.policyName and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName and domain_Policy.versionNo = domain_JobArchive.policyVersionNo AND domain_JobArchive.masterServerId = nb_JobFilesArchive.masterserverId and domain_JobArchive.clientName = nb_JobFilesArchive.clientName and domain_JobArchive.id = nb_JobFilesArchive.jobId and domain_Policy.masterServerId = domain_JobArchive.masterServerId and domain_Policy.name = domain_JobArchive.policyName and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName and domain_Policy.versionNo = domain_JobArchive.policyVersionNo AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId and domain_JobArchive.clientName = nb_JobArchive.clientName and domain_JobArchive.id = nb_JobArchive.id AND nb_JobArchive.masterServerId = nb_JobBackupAttributesArchive.masterserverId and nb_JobArchive.clientName = nb_JobBackupAttributesArchive.clientName and nb_JobArchive.id = nb_JobBackupAttributesArchive.jobId and nb_JobArchive.masterServerId = nb_JobBackupAttributesArchive.masterserverId and nb_JobArchive.clientName = nb_JobBackupAttributesArchive.clientName and nb_JobArchive.id = nb_JobBackupAttributesArchive.jobId AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId and domain_JobArchive.clientName = nb_JobArchive.clientName and domain_JobArchive.id = nb_JobArchive.id AND domain_JobArchive.masterServerId = nb_JobFilesArchive.masterserverId and domain_JobArchive.clientName = nb_JobFilesArchive.clientName and domain_JobArchive.id = nb_JobFilesArchive.jobId and ( ( (domain_JobArchive.startTime BETWEEN '137723688000000000' AND '137723976000000000') AND (DATEDIFF(second, DATEADD(second,21600,DATE(DATEADD(second,-21600,adjust_timestamp(domain_JobArchive.startTime,-14400000) ))),adjust_timestamp(domain_JobArchive.startTime,-14400000 )) < '28800') ) AND ( ((CASE WHEN domain_JobArchive.parentJobId is null or domain_JobArchive.parentJobId=0 or domain_JobArchive.parentJobId=domain_JobArchive.id THEN 1 ELSE 0 END) = '0') ) AND ( ((case when domain_JobArchive.state =106 then 3 when domain_JobArchive.state =3 and domain_JobArchive.statusCode =0 then 0 when domain_JobArchive.state =3 and domain_JobArchive.statusCode =1 then 1 when domain_JobArchive.state =3 and domain_JobArchive.statusCode>1 then 2 else -1 end) IN (2, 3 )) ) AND ( (domain_JobArchive.type IN (0, 6, 28 )) ) AND ( (domain_JobArchive.statusCode NOT IN (200, 288, 191 )) ) AND ( (domain_JobArchive.isValid = '1') ) AND ( (domain_MasterServer.id IN (4708846,4949386,10083258,10113645,10356508 )) ) )
 
 
 
 
 
 
 
 
 

 

 

1 Reply

Re: OpsCenter common custom reports

I'm not going to disect that SQL query right now. Please list which columns have you included in your report.

For example, job primary ID, master server, media server etc...