Database Reference
In-Depth Information
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…
.