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

Go back to the Design mode and click on Save . Navigate to the custom folder created
earlier in this recipe, enter Incidents over time as the name, and click on Save .
Your report is now published to SQL Server Reporting Services and made available to
users using the Service Manager console or a web browser.
Creating a Configuration Item report
To create a Configuration Item report perform the following steps:
1. Start Report Builder.
2. Under New Report , select Table or Matrix Wizard .
3. Select Create a dataset and click on Next .
4. Select the DWDataMart data source connection. If it is not in the list, click on
Browse… to browse to the data source in SQL Server Reporting Services. Then,
click on Next .
5. If prompted for data source credentials, select Use the current Windows user
and click on OK .
6. Click on Edit as Text and type the following SQL query in the query window:
SELECT co.PrincipalName,
os.OSVersionDisplayName,
os.PhysicalMemory,
dc.Manufacturer,
dc.Model,
dc.SerialNumber
FROM
ComputerDimvw co
LEFT OUTER JOIN ComputerHostsOperatingSystemFactvw
coHos ON
co.ComputerDimKey = coHos.ComputerDimKey
AND coHos.DeletedDate IS NULL
LEFT OUTER JOIN OperatingSystemDimvw os ON
coHos.ComputerHostsOperatingSystem_OperatingSystemDimKey
= os.OperatingSystemDimKey
LEFT OUTER JOIN
DeployedComputerRunsWindowsComputerFactvw dcRco ON
co.ComputerDimKey =
dcRco.DeployedComputerRunsWindowsComputer_ComputerDimKey