Jimmy Harper's Operations Manager Blog

Posts in this blog are provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified in the Terms of Use

Jimmy Harper's Operations Manager Blog

  • Pre-reqs for SCOM 2012 Consoles

    Whenever I’m installing SCOM 2012, it takes me a little extra time to get the pre-reqs installed for the Operations Console and Web Console, so I’m adding this to my blog for an easy place to find the download links and steps. Operations Console Before...
  • Alerting on Deadlocks with the SQL Server Management Pack

    Today a customer asked me how to configure SCOM to generate Alerts for SQL Deadlocks. Looking in the SQL Server Management Pack, I found that we have event log Rules for deadlocks for SQL 2005, 2008, and 2012: The Rules are targeted at DB Engine and alert...
  • CPU/Memory Monitors – Include Top Processes in Alert Description

    Here is a Management Pack that I wrote for a customer a while back. The requirement was to take the alerting for CPU Utilization and Available Memory from the Windows Server Management Pack and add the top 5 processes consuming CPU/Memory to the Alert...
  • Several Management Packs Updated, fix for MaxConcurrentAPI Monitor included

    We recently released updated versions of several Management Packs, including the Windows Server OS MP. Below are links to the updated MPs and the fixes that I am aware of:   Windows Server Operating System – Version 6.0.7230.0 Bug fixed: Microsoft...
  • Exporting and Importing User Roles and Notifications in SCOM 2007 and SCOM 2012

    A customer of mine is migrating from SCOM 2007 to a new SCOM 2012 installation and would like to migrate User Roles and Notifications instead of recreating all of them manually. Note that both User Roles and Notifications both reference objects...
  • Get a list of email addresses used in SCOM notifications

    I haven’t blogged in a while, so need to make sure this thing is still on :)  I’ll start with something simple that I used today.  One of my customers is migrating from SCOM 2007 to SCOM 2012 and needs to get a list of all email addresses that...
  • ACS “Event Count” reports

    Here are a couple of ACS reports to show the event count by User, Forwarder, and Event ID. Just import the .rdl files into a folder in SQL Server Reporting Services. The first report “Event Count Overview” shows the top 10 Events, Forwarders...
  • CU6 for OpsMgr 2007 R2 is now available

      CU6 for OpsMgr 2007 R2 is now available at http://www.microsoft.com/en-us/download/details.aspx?id=29850 . You can also find the corresponding KB Article at http://support.microsoft.com/kb/2626076 . Cumulative Update 6 for Operations Manager 2007...
  • Updated Active Directory Management Pack Released - version 6.0.7822.0

      We have just released and updated version of the Active Directory Management Pack (version 6.0.7822.0) that corrects the problems addressed in my recent “ Addendum ” MP.  Once this new ADMP is imported, the Addendum MP can be removed. The...
  • Creating a Group of Windows Computer and Health Service Watcher Objects

    There are a lot of great blogs out there that discuss creating various types of groups ( Kevin Holman and Jonathan Almquist have a number of them), and the stuff that I do in this post won’t be anything that hasn’t been written about before...
  • OpsMgr 2007 R2 Agent Installation Error with Microsoft.VC90.CRT

      I’ve seen this issue a couple of times now…an OpsMgr 2007 R2 Agent installation fails with the following error: Product: System Center Operations Manager 2007 R2 Agent -- Error 1935.An error occured during the installation of assembly component...
  • ADMP – Workaround for Some Broken Win2k8 Rules

    In a previous blog post, I provided an “Addendum” MP to fix some Rules that do not work correctly in the Windows Server 2008 version of the Active Directory Management Pack. All of these Rules have been fixed in the latest version of the ADMP...
  • Logical Disk Fragmentation Report

    Here’s a simple custom report that shows the fragmentation of each logical disk based on the Logical Disk Fragmentation Monitor in the Windows Server Operating System Management Pack. The report has a “Fragmentation Percentage Threshold”...
  • Workflow Failure Queries

      I regularly see customers getting a lot of alerts indicating that workflows have failed to run a script of WMI query…the alert name is usually one of the following: Workflow Runtime: Failed to run a process or script Workflow Runtime: Failed to...
  • Maintenance Mode Scheduling Tool

      The Operations Manager Product Team recently released an Administration Resource Kit for System Center Operations Manager 2007 R2.  One of the tools in the kit is a Maintenance Mode Scheduler….I finally got around to trying this out today...
  • Unhealthy Monitors Report

    I recently put together an “Unhealthy Monitors” report for an OpsMgr Administrator to see which Monitors are causing the most state degradation in the environment. This report lists all monitors that have objects in an unhealthy state, so...
  • 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...
  • 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.
  • 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...
  • 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...
  • 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:
  • 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. ...
  • 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...
  • 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...
  • 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...