Windows Server

Stuart Cash · Guest

All,
I have MOM 2005 Standard Edition and also have installed SQL Reporting
Services on the same server.
When I browse to this server to look at the built in reports I see there is
a Report called "Performance Analysis" under the "Operational Health
Analysis" folder. However when I try to run this report there is no data
displayed and I receive the message below..

There is no data available for this report. This can occur when there is
no relevant data
available for collection, the reports' dependent rules are not enabled
or when none of the
relevant data has been copied to the Reporting database.

My question is where is this report looking for its data (what table, etc.)
and how do I get the data into this location.

Any help would be appreciated..

Thanks
Stuart

James Morey · Guest

Has the Reporting DTS job had a chance to run yet? Basically, the Reporting
database grabs data from the MOM Database using this DTS job
(SystemCenterDTSPackageTask ) and if the job has not run yet, the reports
have no data to use.

You can run the report manually by going to Scheduled Tasks on the Reporting
Server (in your case the same server).

For more information about Reporting (and MOM in general) see the
newly-released MOM 2005 Operations Guide:

Download (Word files):
http://www.microsoft.com/downloads/details.aspx?FamilyId=A0E40758-CAB8-4588-B0F2-1508D84906CC&displaylang=en

Let me know if this does not help.

--
=====================
NOTE - This posting is provided "AS IS" with no warranties, and confers no
rights.

James Morey | Microsoft | Windows & Enterprise Management Division
=====================

"Stuart Cash" <stuart.cash@udex.com> wrote in message
news:u3Npugo8EHA.4072@TK2MSFTNGP10.phx.gbl...

Stuart Cash · Guest

Hi James,

Thanks for the response. The DTS job has ran and has been running
successfully for about two months now, so I don't think there is a problem
with that.
I have created some SQL Reporting Services reports which use the
SDKPerformanceView view in the SystemCenterReporting database and these work
fine. I believe this view gets its data from other tables which are
populated when I create my own MOM Performance Counter rules.
My problem I think is that I do not know where in MOM Administrator the
relevant rules (or possibly a script) are which populate the tables and
views used by the "Performance Analysis" report. I have looked at this
report (i.e. the .rdl) and the in SQL Select statement, the FROM section
mentions the following views (to name but a few) ...
dbo.SC_SampledNumericDataFact_View, dbo.SC_CounterDetailDimension_View,
dbo.SC_ComputerDimension_View.
But what rules/script do I need to get MOM to populate the underlying tables
for these views (or am I looking in the wrong place!!??).

Thanks for your help in this it is much appreciated.

Stuart
____

"James Morey" <jmorey@online.microsoft.com> wrote in message
news:O%2365epo8EHA.1408@TK2MSFTNGP10.phx.gbl...

Stuart Cash · Guest

Hi James,

Just to let you know, the "Performance Analysis" report I can't get to work,
I have checked the SELECT statement it uses and the Views it calls and all
the Views return data via SQL Query Analyser (i.e. I have gone into SQL
Query Analyser and done a return of all data from all the relevant Views and
there is data and counter values returned).
So the underlying data is in the Tables, the views can see it but still
nothing returned in the report (selecting the counters I knwo to have data).
Any bright ones?
Stuart

"James Morey" <jmorey@online.microsoft.com> wrote in message
news:O%2365epo8EHA.1408@TK2MSFTNGP10.phx.gbl...

	Windows Server Forum Index -> MOM	All times are GMT
Page 1 of 1