Creating System Center Advanced Reports - Microsoft System Center Reporting - page 367

5. Select Use a shared connection or report model , click on Browse… , and
browse to and select the newly created data source (this would be called Ser-
viceManager if you followed the steps to create this data source).
6. Click on Test Connection , and on success, click on OK .
7. Right-click on Datasets and click on Add Dataset… .
8. Type DSOpenIncidents as the name and select the Use a dataset embedded
in my report option.
9. Select the ServiceManager data source, select Text query type, and type the fol-
lowing query. Then, click on OK :
SELECT
Id_9A505725_E2F2_447F_271B_9B9F4F0D190C AS [Id],
Title_9691DD10_7211_C835_E3E7_6B38AF8B8104 AS
[Title],
CreatedDate_6258638D_B885_AB3C_E316_D00782B8F688 AS
[CreatedDate],
U.DisplayName AS [AffectedUser]
FROM
MT_System$WorkItem$Incident I WITH (NOLOCK)
LEFT OUTER JOIN Relationship R WITH (NOLOCK) ON
I.BaseManagedEntityId = R.SourceEntityId
AND R.RelationshipTypeId =
'DFF9BE66-38B0-B6D6-6144-A412A3EBD4CE'
AND R.IsDeleted = 0
LEFT OUTER JOIN MT_System$Domain$User U WITH
(NOLOCK) ON
R.TargetEntityId = U.BaseManagedEntityId
WHERE
Status_785407A9_729D_3A74_A383_575DB0CD50ED NOT IN
('2B8830B6-59F0-F574-9C2A-F4B4682F1681',
'BD0AE7C4-3315-2EB3-7933-82DFC482DBAF')
ORDER BY
3 DESC
10. When prompted to Enter Data Source Credentials , select Use the current Win-
dows user or type the password for the service account and then click on OK .
11. In Report Builder, in the Design area, replace the text Click to add title
with Open Incidents .
12. In the toolbar, under Insert , click on Table , and then click on Table Wizard… .