Open Incidents - SCSM

Does anyone know what query Matt used for the count of the incidents in the ServiceManager Integration videocast? The QuickStart has the field but I am having difficulties finding a query to populate that field.


1 Like

Have you taken the scripts from here?

Dont now if the count query is there but you should be able to modify one of them to do a count instead.

-- Select all incidents
	COUNT(*) as Total
FROM IncidentDimvw as incident
Where CreatedDate > DATEADD(d, -120,  GETUTCDATE())

That’ll get all incidents in the SCSM Datawarehouse that are less than 120 days old. If you need to do this for a perspective (computer, app, DB etc) just attach more where clauses to limit the query down to incidents related to your particular object (if you have the SCOM <-> SCSM CI connector enabled, they’ll share the same MonitoringObjectId, which makes it pretty easy).


Thanks Vyper!! That worked like a champ!