SCC Health Check Management Pack Version 2

The version 2 of the MP contains 27 Reports!!! Which are required to run on the Datawarehouse or the Operational Database. There is documentation accompanied how to set up the solution and import the MP.

Please first read the documentation otherwise the MP will fail…..as you already know as SCOM Experts 😉

If you have Feedback or addons to the MP please feel free to send them in!

41 thoughts on “SCC Health Check Management Pack Version 2

  1. Profile photo of Techiedude007Techiedude007

    UPDATE: Instead of selecting “Windows integrated security”, I selected “Credentials stored securely in the report server and use Windows creds when connecting to the data source” and used my SQL/SCOM service acct that I created for the data warehouse. Go figure – the acct I had been using with “Windows integrated security” has SQL admin, DBO access to OpsMgr DB and the DW and I still had to do this…

    What am I missing? I followed the above to the “T” and I’m still getting an error on the OM reports (the DW obviously work fine). I created the new data source; specified the external server for the OperationsManager database (Server500) since they aren’t located on the same server and specified the initial catalog “OperationsManager” and selected Windows integrated security.

    Data Source=Server500; initial catalog=OperationsManager.

    I tried it with the FQDN of the server as well.
    Tried it with and without Integrated Security=SSPI

    Defaults were used when installing the OM db so the name is the default (OperationsManager).

    The error recvd is: “An error occurred during client rendering. An error has occurred during report processing. Cannot create a connection to data source ‘OperationalDataBaseMain”. For more information about this error navigate to the report server on the local server machine, or enable remote errors.”

    Do I need to restart any services after implementing the new data source? Any ideas?

  2. Profile photo of Techiedude007Techiedude007

    Found a funny typo that finally admits what we all knew about monitoring software: it’s nosy. Run the report for “Noisiest Monitors” and the title of the report comes up as “Nosiest Monitors”.

  3. Profile photo of ATFSSCOMATFSSCOM

    I am encountering the same issue. I followed the documentation to the letter, and I am only receiving reports for DW and not for OM.

  4. Profile photo of ATFSSCOMATFSSCOM

    Thanks Techiedude007, I tried your UPDATED steps and that did the trick. I am abLe to run reports on both the DW and OM.

  5. Profile photo of Oskar LandmanOskar Landman Post author

    Thanks for the feedback, changes will be implemented in version 2 which will be released this week!

    Watch for the blog posting on details in version 2 which has alot of improvements!

  6. Profile photo of JeremyJeremy

    Great MP guys. Is there a way to create a report that shows when a alert was sent and to whom or what subscription the alert is tied too? Another request, servers that were placed into MM and user that placed them into MM? Thanks

  7. Profile photo of Oskar LandmanOskar Landman Post author

    Hmmm Subscription is an intresting one will look into this when I have time.

    As for MM the report Misc – Outage and Maintenance Report (DW) should give you this information.

  8. Profile photo of Oskar LandmanOskar Landman Post author

    Sameer,

    good News PeterW has solved this by changing the XML so it is SP1 compatible. Take a look at the blog post for this version of the Management Pack.

    Cheers,

    Oskar

  9. Profile photo of MarcusMarcus

    Hi,

    Connection/credential issue: What worked for me was copying the settings from the DW datasource:

    Add “;integrated Security=SSPI” to the datasource connection string and check “Credentials are not required”

    Good luck

    Marcus

  10. Profile photo of new2sccnew2scc

    Hi Oskar,

    I wanted to leave some feedback Re additions to this MP for version 3.

    One alert report i’ve been struggling badly with and believe it would be VERY useful to have is a report to show all critcial alerts which are in resolution state NEW for > 24 hrs, which can be run for the previous week/month or whatever timeframe. The purpose is that our organisation is introducing internal service level agreements were all critical alerts should be acknowledged within one working day. Therefore we need to be able to run reports to check what alerts fell outside the SLA, and therefore know the service/service owner who needs to address the issues. In my SCOM deployment I have created additional resolution states of Acknowledged (1), Work In Progress (2) ontop of the default New (0) and Closed (255) states.

    At first glance I thought this would be quite straight forward but being a bit of a novice and the more I looked into it, the more difficult is seemed to achive (i posted about this on several sites and looked at others eg http://social.technet.microsoft.com/Forums/en-US/operationsmanagerreporting/thread/b13d7b90-193e-4633-b968-caaafb153798 – I think the problem lies in how to calc the correct time in a particular state since it seems to raise another entry for the alert with the changes resloution state.

    If you have a sample SQL to do this it would be great if you could send me it and if you felt it was worth including in your V3 MP Ideally if you could run a report to show alert Name/desc, Date/time created, Date/Time resolved, Lenthg to time in state (for NEW), closed By, Owner where you could maybe specify via params time period eg previous week/monthetc…

    Many thanks

  11. Profile photo of ruben.cervantesruben.cervantes

    I’ve followed the instructions word for word int he read me file, but for the life of me I’m still getting an error when trying to run OM reports:

    “An error has occurred during report processing. Query execution failed for data set ‘SQL_SCOM_OP’. For more information about this error navigate to the report server on the local server machine, or enable remote errors.”

    I’ve logged into the local report server and there are no errors. I made sure the accounts are set to ‘Credentials stored securely in the report server’ and the ‘Use as Windows credentials when connecting to the data source’ but still no go. Any ideas on what else I could be missing? I can get DW reports working but for the life of me it’s the OM reports that are giving me fits.

    Regards.

  12. Profile photo of RaviRavi

    Is there a way to get a System UP-Time report from SCOM?

    What i see is all availability reports are based on objects and if an object is in critical state, it is calculated in DOWN time.

    Do we have any mechanism from which we just show a Server UP-Time report.

    Any pointer would be highly appreciated.

    Ravi

  13. Profile photo of Oskar LandmanOskar Landman Post author

    Ravi,

    take a look at the MP contest MP “System Uptime MP” from Stephan Hall. It is on the SCC catalog as well.

    His MP will let you report on actual uptime of the system….

    cheers,

    Oskar

  14. Profile photo of Stefan StrangerStefan Stranger

    Hi Guys,

    Love you report but could you please fix the typos in the documentation?

    data source=””;initial catalog=OperationsManagerDW;Inegrated Security=SSPI

    It’s inTegrated Security.

    I’ll probably be no the only one who is copying this connection string from the documentation 😉

    Stefan

  15. Profile photo of Oskar LandmanOskar Landman Post author

    Stefan,

    Strange to see this got it the documentation though as i a can’t imagine I did not copy the string…..

    Will do a total write up of the documentation especially on the Datasource creation.

    Thanks!

  16. Profile photo of Chrischris2005Chrischris2005

    Very neat indeed.

    By the way what is exactly the?: “Top 20 Computers By Performance Count”

    And what do you mean by Performance Inserts in?:

    “Performance – Performance Inserts Per Day (OM)”

  17. Profile photo of djodjo

    Bravo! this is very nice work. We recently went through a SCOM health check engagement with Microsoft and these reports cover a lot of the same issues that the health check does.

    Dave

  18. Profile photo of Michael Skov

    Cool MP, but when i import it, i only get two reports (alerts closed by userid and management packs), how can that be? Thanks!

  19. Profile photo of Sven WellsSven Wells

    Having an issue with this MP. When I select any of the reports, I get the following error:
    "An error has occurred during report processing.
    Cannot create a connection to data source ‘OperationalDataBaseMain’.
    Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’."

    The data source is actually named "OperationalDatabaseMain".

    What else do I need to look at to fix this?
    Thanks,
    Sven

  20. Profile photo of Oskar LandmanOskar Landman Post author

    Hi Sven,

    did you create the Datasource and made sure you selected the correct security settings?

    The documentation still has some typo’s in it.
    I will rewrite the documentation in the mean while please change the datasource name accordingly.

    The account you are running the reports with have enough permissions?
    SCOM Administrator

    I did a write up on a scripted version for creating the datasource a couple of months back but never get to finish it.
    Maybe now is the time for a write up 🙂

    promise to come with a new version the upcomming weeks.

    CHeers,
    Oskar

  21. Profile photo of Les BowmanLes Bowman

    It took about 10 minutes but all my reports showed up 🙂 Initially I only had 12, after a refresh the others showed up.

    I am having an interesting result though. On the Top 20 Alerts by Alert count for instance, the results of the Citrix alerts show up in multiple languages…

    2700 La sesión de Citrix estuvo inactiva demasiado tiempo Una sesión de Citrix ha estado inactiva demasiado tiempo (ID de sesión ID {0} del usuario {1}). 5d205c31-5669-fc39-3cad-91720876cca4 AB58F69C-B5C0-C199-D0FC-A1A0D34DD202
    1755 Citrix session idle too long A Citrix session has been idle for too long (session ID {0} for user {1}). 5d205c31-5669-fc39-3cad-91720876cca4 AB58F69C-B5C0-C199-D0FC-A1A0D34DD202
    860 Las propiedades de una impresora de red o del cliente no están disponibles Las propiedades de la impresora del cliente {0} no han podido transferirse. Controlador de impresora: {1}. 34fd0b2c-b272-9560-747c-f9bd028667ef 034E1B9B-209E-F9A2-F534-51925F82DEDE
    810 La durée d’inactivité de la session Citrix est trop longue Une session Citrix a été inactive trop longtemps (ID de session {0} pour l’utilisateur {1}). 5d205c31-5669-fc39-3cad-91720876cca4 AB58F69C-B5C0-C199-D0FC-A1A0D34DD202
    675 Citrix Sitzung zu lange im Leerlauf Eine Citrix Sitzung hat sich zu lange im Leerlauf befunden (Sitzungs-ID {0} für Benutzer {1}). 5d205c31-5669-fc39-3cad-91720876cca4 AB58F69C-B5C0-C199-D0FC-A1A0D34DD202
    644 Script or Executable Failed to run {0} c72731b1-eb45-a86a-ba4f-1e43460e6cc4 5CB85324-750C-2714-25D7-F9407A9BA180
    559 Client or network printer properties are not available Printer properties for client printer could not be transferred from printer {0}. Printer driver: {1}. 34fd0b2c-b272-9560-747c-f9bd028667ef 034E1B9B-209E-F9A2-F534-51925F82DEDE

  22. Profile photo of HarryHarry

    Pretty neat reports I must admit, however for few reports it does not ask for start date/time and end date/time, it just runs. What do you suggest I do in such cases ?

  23. Profile photo of pfunck123pfunck123

    Hello All,
    I am not getting the folder under reports, SCC Health Check Reports, I followed the word doc to ensure that the datasource was created to the OperationsManager server , than imported the MP.

    Thanks in advance for your help.
    Pfunck

  24. Profile photo of SW64SW64

    Used this extensively with SCOM 2007 R2. Recently completed a SCOM 2012 implementation, installed this MP, and I only get 2 reports – Alerts Closed by UserID & Misc – Management Packs. And the Misc – Management Packs report gives an error when it’s run. Has anyone had success with this using SCOM 2012?

  25. Profile photo of SW64SW64

    Shortly after posting my question I got a deployment error from the Data Warehouse a portion of which looks like this:

    Data Warehouse failed to deploy reports for a management pack to SQL Reporting Services Server. Failed to deploy reporting component to the SQL Server Reporting Services server. The operation will be retried.
    Exception ‘DeploymentException’: Failed to deploy reports for management pack with version dependent id ‘1e407d45-3391-49ca-90f9-365b66ea3f9f’

    I have removed the MP for now.

  26. Profile photo of Natascia HeilNatascia Heil

    I have the same problem after upgrading our environment to SCOM2012 on SSRS 2008 R2. It states: The value of parameter ‘DataSources’ is not valid. The data source is created correctly, because it worked within the old environment. So what has changed with the new versions?

  27. Profile photo of Ian Blyth (UK)Ian Blyth (UK)

    I have installed this on 2 different managemeng groups running SCOM 2012 SP1 and all the reports I have tried work.

    My main issue is with the date format. When I run the report the date at the top corner is in US format (month/day/year). When I run one of the standard out of the box reports I get the correct UK format (day/month/year). It would be nice to get that fixed so it picks up the date locale from the server it is running on.

  28. Profile photo of sebastiansebastian

    Hi,

    I just returned to office after attending SCU2013 DACH in Bern.
    I created the Report’s Data Source, Connection Test is okay.
    Importing the MP is without errors.
    Reports are shown up in the ReportServer. But there is no folder, no new Report in my OpsMgr Console’s Report Pane.

    Any Ideas ?

    Thanks
    sebastian

  29. Profile photo of sebastiansebastian

    Just want to give you an update.
    The next day Reports were available in the Reports Pane.

    But to have them work I needed to modify Data Source’s Definition.
    We granted Read Access to OperationsManager for the DW-Reader Account.
    Then I added the DW-Reader Account credentials to the DataSource.

    In the Section “Connect using:” I checked “Credentials stored securely in the report server”, entered Username and Password, Check “Use as Windows credentials when connecting to the data source”.

    Now it works great !

    It undiscovered immediately some bad situations.

    Thanks again!

    sebastian

     

  30. Pingback: OpsMgr Administration 101 | System Center Operations Manager 2012

Leave a Reply