Active Alerts Report

  NOTE:  This report uses the Operations Database instead of the Data Warehouse….in order for it to work, you must create an SRS Data Source for the OpsDB…Kevin Holman has instructions for this here. Here’s a simple report to show all current Active Alerts.  Just select the desired Severity, Resolution State, and Time Zone (to…


Alert Count by Hour Report

  Very simple report which shows the number of Alerts generated in each hour of a given day….just select the date and the GMT offset and run it.   Alert count by


ACS Database Dashboard Report

  Here’s a little report that I put together to get a look at what is going on in the ACS Database.  The report will show: Number of Events in the DB Number of days represented in the DB Max Events Per Day Average Events Per Day Partition Count DB Size DB Free Space Top…


Exchange 2007 Mailbox Count Report

  The Exchange 2007 Management Pack for MOM 2005 included a Mailbox Count report which was not included in the OpsMgr 2007 version of the Management Pack. I’ve recently taken the MOM 2005 version of this report and converted it to work in OpsMgr 2007.  I had to modify some minor things in the report,…


Group Membership Count Report

  Here’s a quick little report to show the number of objects in each group.  You have the option to select “All Groups” or “Computer Groups”, and can also enter a “Group Filter” to narrow down the list:   Group Membership


Exchange 2003 “Mailboxes” and “Database Sizes” Reports for OpsMgr 2007

  The Exchange 2003 Management Pack for MOM 2005 contains a few reports that are not included in the OpsMgr 2007 version of the Management Pack.  Two of these are the “Exchange Mailboxes” and “Exchange Database Sizes” reports. I’ve recently taken these two reports and converted them to work in OpsMgr 2007.  All I really…


Monitor State Report

  OpsMgr Health Explorer allows you to look at the State of all Monitors for a specific object.  But, what if you want to look at the State of a specific Monitor on ALL objects that it applies to?  For example, I want to see the state of the “SQL Server Windows Service” Monitor on…


ADMP for Windows Server 2008 – Alerts not generated for some Rules

  I recently found that many Event Log rules in the Active Directory Management Pack for Windows Server 2008 (version 6.0.7065.0) do not work correctly, resulting no alert being generated for these rules.  This is happening because the MP uses the old event sources from Server 2003 in its event rules, rather than the new…


Office update breaks "Company Knowledge" Editing

A recent Security Update for Word 2007 is breaking the ability to edit Company Knowledge in OpsMgr.  After installing KB2251419, when you try to edit Company Knowledge, you get: “The server threw an exception.  (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))”   To resolve the problem, you’ll need to uninstall this update from Add/Remove Programs.  However, keep…


Powershell Commands to configure Gateway Server / Agent Failover

  UPDATE:  Some of these commands have been changed for OpsMgr 2012, so I’ve created updated scripts at the bottom of this post that should work in 2012. I’ve assisted a few customers with configuring Gateway Servers/Agents for failover lately, so I figured I’d post the commands that I use for this.   Why do…