SCOM 2012 Utilization Reports Processor Data Missing

November 21, 2012 3:06 pm / 16 Comments /

Did you lose your Processor data after updating to Base OS MP version 6.0.6989.0?

Download these updated RDL Files and upload them to your reporting server instance to get Processor % back in your Utilization reports.

Utilization Report Addendum: http://www.scomgod.com/wp-content/uploads/2012/12/SCOM_GOD_Processor_Information_Addendum.zip

Performance by System Report Addendum: http://www.scomgod.com/wp-content/uploads/2012/12/SCOM_GOD_Microsoft.Windows.Server.Reports.PerformanceBySystem2.zip

 

Posted in: SCOM Downloads

16 Thoughts on “SCOM 2012 Utilization Reports Processor Data Missing”

  1. Kev on December 19, 2012 at 1:54 pm said:

    Thanks for your files.

    I have tried these and get an error:

    Note: The following information was gathered when the operation was attempted. The information may appear cryptic but provides context for the error. The application will continue to run.

    Microsoft.Reporting.WinForms.ReportServerException: The report server cannot process the report or shared dataset. The shared data source ‘DataWarehouseMain’ for the report server or SharePoint site is not valid. Browse to the server or site and select a shared data source. (rsInvalidDataSourceReference)
    at Microsoft.Reporting.WinForms.ServerReportSoapProxy.OnSoapException(SoapException e)
    at Microsoft.Reporting.WinForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod)
    at Microsoft.Reporting.WinForms.ServerReport.EnsureExecutionSession()
    at Microsoft.Reporting.WinForms.ServerReport.GetParameters()
    at Microsoft.EnterpriseManagement.Mom.Internal.UI.Reporting.Parameters.ReportParameterBlock.Initialize(ServerReport serverReport)
    at Microsoft.EnterpriseManagement.Mom.Internal.UI.Console.ReportForm.SetReportJob(Object sender, ConsoleJobEventArgs args)

    My Guess, the reports were build in 2005, we are using 2008 R2. Is this the case?

    • admin on December 19, 2012 at 2:17 pm said:

      Hello and thanks for the comment. You need to go into the properties of the report in your report server web interface and set the properties of the data source. This is well documented in other SCOM reporting blog posts.

  2. Walter Chomak on February 8, 2013 at 12:02 am said:

    A++! Thank you. Perfect and solved a huge headache.

    • admin on February 8, 2013 at 4:01 am said:

      No problem. It saved my ass too! What a hassle. :)

    • Saravanan on May 2, 2013 at 11:18 am said:

      can you please tell me what you did to fix this , I am very new to this and facing the same problem
      what is the location i need to upload these files

      Thanks in Advance

      • admin on May 2, 2013 at 1:04 pm said:

        Hi you need to open your ReportServer Web UI and select the folder you wish to place them, I would choose the Windows Server Reports, where the originals are. Choose upload to upload the files there. You then need to adjust report to connect to the DW.

        I should have done a step by step for this but all of the information needed to add RDL files is on the Web. You need to learn how to manage ReportServer and all of that info can be found with simple google searches. :)

  3. Nicklas on February 19, 2013 at 10:26 am said:

    Hi!
    Where to put the files at the reporting area?? Quite unclear!!

  4. admin on March 6, 2013 at 8:17 pm said:

    Nicklas – you need to select Details to and then browse the tree to see the DW option.

    Or use:
    Provider=SQLOLEDB;Server=YOUR-SERVER;Database=OperationsManagerDW;Integrated Security=SSPI

  5. Jay on March 14, 2013 at 5:49 pm said:

    Anyone have problems with this not returning data for non-R2 servers? I can get data for 2008 R2, but non-R2 servers still show nothing.
    Thanks
    Jay

  6. admin on March 14, 2013 at 7:51 pm said:

    Jay,

    My report will populate processor for Windows 2008R2.

    Have you deployed it?

    The issue you are possibly having is rectified with my update.

    Thanks
    SCOM GAWD

  7. Jay on March 15, 2013 at 5:04 pm said:

    Hi SG,
    Yes, 2008 R2 servers return CPU time data fine, its the non-R2 servers that are not returning anything.

    Thanks
    Jay

  8. admin on March 20, 2013 at 7:56 pm said:

    I don’t have any suggestions unfortunately. My report returns both for me successfully in SCOM 2012 SP1 and 2007 R2.

  9. Jay on March 22, 2013 at 2:46 pm said:

    Well, that sucks

  10. bkhsms on March 28, 2013 at 6:52 pm said:

    Great work on these reports. I see where you updated the Processor Information counter object in the report. I’m using the drill down for each computer object, in specific where the version 2 report hands off to the canned performance by system report for the specific computer object. I edited the performance by system report row group and chart properties for the processor to look at the filter for Processor Information counter object; however, I’m still getting blank reports. I drilled into the sproc as well, dbo.[Microsoft_SystemCenter_Report_Performace_By_System], where it refers to a counterlistobjectxml . I assume this is the library where the counter objects are referred to, but I cannot find it in the db. Wonder if you have run into any such parameters and know if they are dynamically created given input or if this is a resident file in the installation folder. Thanks in advance.

    • admin on March 28, 2013 at 7:07 pm said:

      Thanks, I got help from an inside friend at MS … :)

      I have only used this report for the Top Utilization data. I’ve never used them for drilling down. I’m not sure what to suggest to be honest.

Leave a Reply

Post Navigation