SCOM 2007 Report Catalog

Data from two sources is combined when report hierarchy is displayed in the Operations Manager console. List of reports always comes from SSRS while additional metadata like report display name and knowledge come from management packs.

OpsMgr console always looks for everything under SSRS root folder and shows it under the Reporting node in the console. That’s right, everything that is visible even if this is not part of a management pack. That said you can simply create any directory in the SSRS, drop a report in it and it will be displayed inside the console. Is that the way to go with the custom reports? May be or maybe not. It all depends again on what you actually trying to accomplish.

Creating a report and just dropping it to the SSRS is definitely the easiest way to go. This will work just fine for certain cases where you need to quickly share some simple reports with others in your organization. This solution doesn’t scale however and also has some side effects. One of the things to look for is automatic report deployment.

SCOM 2007 assumes that all reports come in management packs. If management pack contains reports they are going to be automatically deployed to the SSRS when the time comes. That means that when all dependencies for these reports are ready (database objects are created all dependent management packs are deployed etc) deployment module creates a directory with management pack ID under SSRS root folder and puts all reports in this management pack in it. It also puts images, parameter block definitions and other resources if they are defined in the management pack. Names for all the objects are IDs again.

Why use IDs for names? The answer is simple: localization. Remember I said that SCOM combines information from SSRS and management packs when displays them in the console? That’s how it does it. When IDs match SCOM assumes that this is a management pack object and displays it metadata instead of SSRS name. Try to compare what you see in the SSRS Report Manager with the Console report view and you quickly understand what I am talking about.

Imagine now that you created a folder in SSRS and put some reports in it. If all your employees speak one language localization is not a problem for you, but you still need to watch for name collisions. If some time down the road you install a management pack that happens to have the same ID as your folder name your reports are going to be overwritten without notice. You would also need to care about dependencies yourself. If your custom report happened to depend on some management pack objects or reports from other management packs SCOM is not going to stop administrator from deleting this management pack from the system if your reports are not in a dependent management pack. The reports will just simply stop working for you.

Packaging report in a management pack is not that difficult and I encourage everybody to do so. It will save you time and effort in a long run.

Comments (4)

  1. Eugene Bykov says:

    In my previous post “ Authoring reports for SCOM 2007 ” I said that there are basically tree ways to

  2. Eugene Bykov says:

    It’s unfortunate but SCOM 2007 RTM does not have an ability to publish favorite reports back to the reporting

  3. OZroute says:

    Is there a way to reinstall reports in case someone has to reinstall reporting component from scratch?

    Scenario: SQL Reporting is hosted off the dedicated server which also has SCOM reporting installed.

    What would be the correct recovery procedure if this server fails ro gets corrupted for some reason?

    There is no clear way to re-import reports as MP fails to import if the same MP already exists.

  4. eugenebykov says:

    MP reports are deployed to the SSRS automatically when they are installed on the Management Group. If for any reason you want to redeploy reports for a given MP you can just simply delete MP folder on the SCOM SSRS instance and report deployment module recreates it.