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

3. Right-click on Data Sources and click on Add Data Source… .
4. Enter OperationsManager as the name.
5. Select Use a shared connection or report model , click on Browse… , and
browse to the newly created OperationsManager data source.
6. Click on Test Connection , and on success, click on OK .
7. Right-click on Datasets and click on Add Dataset… .
8. Enter DSActiveAlerts as the name and select the Use a dataset embedded
in my report option.
9. Select the OperationsManager data source, select Text query type, and type the
following query. Then, click on OK :
SELECT
MonitoringObjectPath AS [Path],
MonitoringObjectDisplayName AS [Source],
ISNULL(AlertStringName, Name) AS [Name],
TimeRaised AS [Created]
FROM
AlertView
WHERE
ResolutionState <> 255
ORDER BY
4 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 click on OK .
11. In Report Builder, in the Design area, replace Click to add title with
Active Alerts .
12. In the toolbar, under Insert , click on Table and then click on Table Wizard… .
13. In New Table or Matrix wizard , select Choose an existing dataset in this re-
port or a shared dataset , select the DSActiveAlerts dataset, and then click on
Next .
14. Drag and drop all the fields from the Available fields list to the Values area, and
then click on Next .
15. On the Choose the layou t page, click on Next , select the desired style, and then
click on Finish .
16. Change the columns' width and font sizes so that the rendered report is displayed
properly. You can click on the Run button in the Home toolbar at any time to
render data. Click on Design in the Run toolbar to return to the Design mode.
17. Right-click on the footer area in the report and click on Remove Page Footer .