Menu Close

A SQL query to get task output data from the OpsDB

Something I wrote to get a report on tasks being run on the OpsDB, and their output: select tv.Name as TaskName, bme.fullname as ObjectName, jsv.SubmittedBy, jsv.TimeStarted, jsv.TimeFinished, jsv.Output, tv.Description as TaskDescriptionfrom JobStatusView jsvinner join TaskView tv on jsv.MonitoringTaskId = tv.Idinner join BaseManagedEntity bme on jsv.TargetMonitoringObjectId = bme.BaseManagedEntityIdorder by TimeStarted DESC…