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

6. Under Datasets , add a dataset named DSRunbook . Select the Use a dataset em-
bedded in my report option, select the Orchestrator data source, select the
Text query type, and type the following query. Then, click on OK :
SELECT * FROM
[Orchestrator].[Microsoft.SystemCenter.Orchestrator].Runbooks
WHERE Id = @Runbook
7. Under Datasets , add a dataset named DSDiagram . Select the Use a dataset em-
bedded in my report option, select the Orchestrator data source, select the
Text query type, and type the following query. Then, click on OK :
SELECT Diagram FROM
[Orchestrator].[Microsoft.SystemCenter.Orchestrator].RunbookDiagrams
WHERE RunbookId = @Runbook
8. Under Datasets , add a dataset named DSParameters . Select the Use a dataset
embedded in my report option, select the Orchestrator data source, select
the Text query type, and type the following query. Then, click on OK :
SELECT * FROM
[Orchestrator].[Microsoft.SystemCenter.Orchestrator].RunbookParameters
WHERE RunbookId = @Runbook
9. Under Datasets , add a dataset named DSActivities . Select the Use a dataset
embedded in my report option, select the Orchestrator data source, select
the Text query type, and type the following query. Then, click on OK :
SELECT * FROM
[Orchestrator].[Microsoft.SystemCenter.Orchestrator].Activities
WHERE RunbookId = @Runbook
10. Under Datasets , add a dataset named DSInstances . Select the Use a dataset
embedded in my report option, select the Orchestrator data source, select
the Text query type, and type the following query. Then, click on OK :
SELECT TOP 20 * FROM
[Orchestrator].[Microsoft.SystemCenter.Orchestrator.Runtime].RunbookInstances
WHERE RunbookId = @Runbook ORDER BY CreationTime DESC