How grooming and auto-resolution work in the OpsMgr 2007 Operational database

How Grooming and Auto-Resolution works in the OpsMgr 2007 Operations DB In a simplified view to groom alerts…..   Grooming of the ops DB is called once per day at 12:00am…. by the rule:  “Partitioning and Grooming”  You can search for this rule in the Authoring space of the console, under Rules.  It is targeted…


System Center Operations Manager SDK service failed to register an SPN

System Center Operations Manager SDK service failed to register an SPN     Have you seen this event in your RMS OpsMgr event logs?   Event Type:      Warning Event Source:   OpsMgr SDK Service Event Category:            None Event ID:          26371 Date:                12/13/2007 Time:                2:58:24 PM User:                N/A Computer:         RMSCOMPUTER Description: The System Center Operations Manager SDK…


Agent discovery and push troubleshooting in OpsMgr 2007

OpsMgr 2007 Agent troubleshooting: There is a GREAT graphical display of the Agent discovery and push process, taken from:   Agent Prerequisites: Supported Operating System Version (see below) Windows Installer 3.1 MSXML 6 Parser Agent push requirements (including firewall ports): The account being used to push the agent must have local admin rights on…


Antivirus Exclusions for MOM and OpsMgr

Antivirus Exclusions in MOM 2005 and OpsMgr 2007:    Processes:   Excluding by process executable is very dangerous, in that it limits the control of scanning potentially dangerous files handled by the process, because it excludes any and all files involved.  For this reason, unless absolutely necessary, we will not exclude any process executables in…


Adding custom information to alert description (s) and notifications

  Alert Description Variables: The following section contains variables for the Alert Description only. For event Rules (Alert Description): EventDisplayNumber (Event ID):             $Data/EventDisplayNumber$ EventDescription (Description):               $Data/EventDescription$ Publisher Name (Event Source):              $Data/PublisherName$ EventCategory:                                    $Data/EventCategory$ LoggingComputer:                                $Data/LoggingComputer$ EventLevel:                                          $Data/EventLevel$ Channel:                                              $Data/Channel$ UserName:                                           $Data/UserName$ EventNumber:                                      $Data/EventNumber$ Event Time:                                          $Data/@time$ For event Monitors (Alert Description): EventDisplayNumber (Event ID):            $Data/Context/EventDisplayNumber$…


Bulk enable of agent proxy setting

As you know…. this setting must be enabled for many agents under OpsMgr 2007. Primarily – for Active Directory, Exchange, Cluster node servers, SMS, and Sharepoint 2007 server agents. We have a ton of choices out there on how to easily enable this setting for multiple computers at once: GUI tool: Command line tool: …


Useful MOM 2005 SQL queries

SCDW/DTS:   Primary 6 tables that SCDW data is retained in: SC_AlertFact_Table SC_AlertHistoryFact_Table SC_AlertToEventFact_Table SC_EventFact_Table SC_EventParameterFact_Table SC_SampledNumericDataFact_Table Commands to execute to modify the data retention age:  Please run these commands changing the values from 385 to the number to the number of days of data to be retained: Exec p_updategroomdays ‘SC_AlertFact_Table’, 385 Exec p_updategroomdays ‘SC_AlertHistoryFact_Table’,…


Useful Operations Manager 2007 SQL queries

This post has been archived.  Please see the new posting for SQL queries for SCOM at: