cancel
Showing results for 
Search instead for 
Did you mean: 

Re: Opscenter Custom Report to exclude few error codes

NBU_VTL
Level 1

Need help trying to get this SQL query to work in OpsCenter for a 24 hour period

select TOP 100 START AT 1 nom_NBJob.ServerName as "nom_NBJob.ServerName",nom_NBJob.ClientName as "nom_NBJob.ClientName",nom_NBJob.JobID as "nom_NBJob.JobID",nom_NBJob.PolicyName as "nom_NBJob.PolicyName",nom_NBJob.ScheduleName as "nom_NBJob.ScheduleName",nom_NBJob.ExitStatus as "nom_NBJob.ExitStatus",adjust_timestamp_dst(nom_NBJob.StartTime ) as "nom_NBJob.StartTime",adjust_timestamp_dst(nom_NBJob.EndTime ) as "nom_NBJob.EndTime",CAST(( nom_NBJob.kBytes* 1024) AS NUMERIC(30,6)) as "nom_NBJob.kBytesInBytes" from nom_NBJob where ( (nom_NBJob.IsClientVirtual = 1) ) AND ( ( (nom_NBJob.HostGUID IN (14293 )) ) AND ( (nom_NBJob.ClientId IN (330590, 330591, 330592, 330593, 693128, 693129, 330589, 330594, 327225, 330595, 327227, 327226 )) ) AND ( ( (nom_NBJob.HostGUID IN (61,14293 )) ) ) ) ORDER BY UPPER("nom_NBJob"."ClientName" ) ASC

1 REPLY 1

sdo
Moderator
Moderator
Partner    VIP    Certified

There should be plenty of OpsCenter example reports over here:

https://vox.veritas.com/t5/OpsCenter/bd-p/opscenter

...maybe something there will help you.