04-17-2020 01:10 PM
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
04-21-2020 12:33 AM
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.