[OpsMgr 2007R2][OpsMgr 2012] Usefull reports

The reports provided with System Center Operations Manager (SCOM) may sometimes seem particularly poor in terms of daily operations on the product. Today, Jean-Sébastien DUCHÊNE offers some report that are very usefull when you are working on overrides when you upgrade Management Packs, on groups and agents

Do not forget to create a datasource targeting to the operational database with security rights necessary to generate the report. This reports works with System Center Operations Manager 2007 R2, System Center 2012 Operations Manager and SQL Server 2008 RTM/R2.

Overrides stored in a non - sealed MP
Overrides stored in non sealed MPs for a dedicated MP
Overrides by type for a dedicated MP
Overrides stored in all non - sealed MPs
Overrides changes by date
Monitor, rule and discovery chages by date
Add, update and remove MPs by date
Agents state
Non accessible agents
Groups stored by MP
Groups for an agent
List alerts by computer for a Group
Summary and detailled alert report for an agent
Detailled performance (RAW) for an agent
Discovered entities for an agent
Maintenance mode history for an agent


Thanks to Jean-Sébastien - this helped me a lot in my all day work !

This posting is provided "AS IS" with no warranties.