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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics