How to create management pack for the custom reports in SCOM 2007?
Heya - I am new to SCOM and SSRS.
After some research about SCOM I found this http://technet.microsoft.com/en-gb/library/dd362600.aspx
and managed to create a custom report that uses a store procs to get data from the OperationsManagerDW.
I now need to create a management pack for my report.
My report accepts three parameters - @StartDate, @EndDate and @ClusterName
As per the link mentioned above, I need to specify the parameters in the REPORT PARAMETER DEFINITON BLOCK.
Please could someone advise me where should this REPORT PARAMETER DEFINITON BLOCK appear in the management pack xml.?
At the moment the management pack xml looks like.
<ManagementPack ContentReadable="true" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<Manifest>
<Identity>
<ID>XX.SCOM.Reports.CustomReports.MP</ID>
<Version>1.0.0.0</Version>
</Identity>
<Name>XX.SCOM.Reports.CustomReports</Name>
<References>
<Reference Alias="Reporting">
<ID>Microsoft.SystemCenter.DataWarehouse.Report.Library</ID>
<Version>6.0.6278.0</Version>
<!--Update this from the SCOM Server ???-->
<PublicKeyToken>31bf3856ad364e35</PublicKeyToken>
</Reference>
</References>
</Manifest>
<Reporting>
<Reports>
<Report ID="XX.SCOM.Reports.PoolUtilization" Accessibility="Public" Visible="true">
<Definition>
******MY REPORT DEFINITION**********
</Definition>
</Report>
</Reports>
</Reporting>
My second question is the thrid paramterto the stored procedure is of type VarChar -What data type should I use to map this in the report parameter definition block?
Thanks
Shiva S
Shiva Sadayan
January 19th, 2011 7:34am
Hi,
Regarding Parameter Block, I would like to share the following with you for your reference:
Report parameters block
http://blogs.msdn.com/b/eugenebykov/archive/2007/06/15/report-parameters-block.aspx
Appendix A - Reporting Management Pack Schema
http://technet.microsoft.com/en-us/library/dd362641.aspx
Hope this will give you some hints.
Thanks.
Nicholas Li - MSFT
Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Free Windows Admin Tool Kit Click here and download it now
January 20th, 2011 10:07pm
Hi,
Regarding Parameter Block, I would like to share the following with you for your reference:
Report parameters block
http://blogs.msdn.com/b/eugenebykov/archive/2007/06/15/report-parameters-block.aspx
Appendix A - Reporting Management Pack Schema
http://technet.microsoft.com/en-us/library/dd362641.aspx
Hope this will give you some hints.
Thanks.
Nicholas Li - MSFT
Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
January 20th, 2011 10:07pm