Database Reference
In-Depth Information
There's more...
The report we just created is showing realtime data which you want to access frequently.
You have the option to present this report in the Work Items section instead of the Report-
ing section of the Service Manager console.
Integrating the dashboard in the Service Manager console
Service Manager allows you to display any web page inside the Service Manager console.
As reports hosted in SQL Server Reporting Services can be accessed via a web browser, we
can display the report in the Service Manager console in the Work Items,
wunderbar
!
To do
so, make sure that the report was saved with the name
Incident Dashboard
to SQL
Server Reporting Services in a custom folder. Create an XML file named
Cus-
tom.IncidentDashboard.View.xml
and type the code segment from the
Cus-
Websites, Chapter Code, and Community Resources
, into the XML file using an XML text
editor (for example,
NotePad++
).
Make sure that you change the
Source
attribute of the
<WebBrowser>
tag to point to
the correct URL. Replace
[SSRSServerName]
with the fully qualified domain name of
the server hosting SQL Server Reporting Services and also check the path to the report and
adjust it if required.
Save the XML file and import the management pack into Service Manager. Restart the Ser-
vice Manager console, navigate to
Work Items
, and click on the
Work Items
root ele-
ment, as shown in the following screenshot: