Creating Reports for System Center Service Manager and Orchestrator - Microsoft System Center Reporting - page 330

SELECT
'Open Incidents' AS [Title],
COUNT(*) AS [Count]
FROM
MT_System$WorkItem$Incident WITH (NOLOCK)
WHERE
Status_785407A9_729D_3A74_A383_575DB0CD50ED NOT IN
('2B8830B6-59F0-F574-9C2A-F4B4682F1681',
'BD0AE7C4-3315-2EB3-7933-82DFC482DBAF')
UNION
SELECT 'Unassigned Incidents' AS [Title],
COUNT(*) AS [Count]
FROM
MT_System$WorkItem$Incident WITH (NOLOCK)
WHERE
Status_785407A9_729D_3A74_A383_575DB0CD50ED NOT
IN('2B8830B6-59F0-F574-9C2A-F4B4682F1681',
'BD0AE7C4-3315-2EB3-7933-82DFC482DBAF')AND NOT
EXISTS(SELECT * FROM Relationship WITH (NOLOCK)
WHERE
SourceEntityId = BaseManagedEntityIdAND
RelationshipTypeId =
'15E577A3-6BF9-6713-4EAC-BA5A5B7C4722'
AND IsDeleted = 0)