Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 947678 - Last Review: February 14, 2008 - Revision: 1.1
How to extract an SQL statement from a Microsoft Operations Manager 2005 report
When you try to troubleshoot Microsoft Operations Manager (MOM) Reporting Services issues, you may want to extract the SQL statement that is being used to pull the data. You may want to extract this statement to query the SystemCenterReporting database directly. This article describes how to extract an SQL statement from a MOM 2005 report.
To create editing reports for MOM 2005 Reporting Services, the computer must meet the following requirements:
- The computer must have Microsoft Visual Studio .NET 2003 installed.
- The computer must have SQL Server Reporting client components installed.
- The computer must have a connection to the System Center data warehouse and to the SQL Reporting Services servers that are used for report development.
To extract the SQL statement from a MOM 2005 report, follow these steps:
- Select the report that you want to use, and then click the Properties tab.
- Click Edit, and then select a location in which to save the .rdl file.
- Start Visual Studio .NET 2003, point to New, and then click Project on the File menu.
- Under Business Intelligence Products, click Report Project, and then click OK.
- To create a connection to the database, right-click Shared Data Sources, and then click Add New Data Source.
- In the Data Link Properties dialog box, type the name of the instance in which the SystemCenterReporting database resides, click the Windows NT integrated security option, and then select the SystemCenterReporting database.
- Click Test Connection to validate your connection to the database, and then click OK.
- Right-click the new connection, and then rename it as SCDW.rds.
- Right-click Reports, point to Add, and then click Add Existing Item.
- Click the .rdl file that you saved in step 2.
- Double-click the report to open it in the Visual Studio .NET 2003 Design Environment.
- Click Preview, type the appropriate criteria, and then verify that the report returns the data that you expect.
- Click the Data tab, and then select the appropriate dataset from the Dataset list. This step displays the transact-SQL for the selected dataset of the report.
Note After you extract the SQL statement from a MOM 2005 report, you will probably also have to edit the statement accordingly. For example, you may also have to supply literal values for all declared parameters.
APPLIES TO
- Microsoft Operations Manager (MOM) 2005
| kbexpertiseinter kbhowto kbinfo KB947678 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate