Grooming process in the Operations Database

This is a continuation of my other post, on general alert grooming: How grooming and auto-resolution work in the OpsMgr 2007 Operational database   Grooming of the OpsDB 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…

5

Print Server management pack fills the Operational DB with TONS of perf data

This is something I have noticed in MOM 2005, and seems to be the same in the conversion MP for OpsMgr 2007.  (Version 6.0.5000.0 of the Microsoft.Windows.Server.Printserver (Converted) MP).  When you import this MP, it will fill the Operational and reporting databases with performance data about print jobs and queues, if you have a large…

1

Installing the OpsMgr 2007 agent on an ISA 2004 or ISA 2006 server

When you want to manage and monitor an ISA server, you need to install the OpsMgr agent. However, there is no guide published for the OpsMgr 2007 ISA MP…..   It comes with the MOM 2005 guide.  In ISA, there was a system policy which you could enable for MOM.  This would open the necessary ports…

3

Failed tasks aren’t groomed from the Operational Database

This appears to be present up to RC-SP1 version, build 6.0.6246.0   In the Task Status console view – I noticed an old failed task from 2 months ago….. however, my task grooming is set to 7 days.   To view the grooming process: http://blogs.technet.com/kevinholman/archive/2007/12/13/how-grooming-and-auto-resolution-work-in-the-opsmgr-2007-operational-database.aspx Basically – select * from PartitionAndGroomingSettings will show you all…

2

Creating a Group based on OU (Organizational Unit) in Active Directory

  Here is a really cool feature of Opsmgr:  the ability to create groups easily based on any discovered attribute of an object.   OU is something that is part of the Windows Computer object discovery.  If you examine a state view – you will see in the details pane discovered information… and OU is…

10

Repeating event monitor alert description variables don’t work

  This is current as of RC-SP1 version of OpsMgr 2007. When you create a repeating event monitor, and use the GUI to add in some Alert description variables, such as event ID, Description, etc… you will find that they do not work.  Below are the correct variables to use for repeating event monitors:  …

5

Configuring Notifications – to include specific alerts from specific groups and classes

So…. Say I am an Exchange Administrator in a global company…. in the good old USA. My company has recently implemented OpsMgr 2007 to monitor our Exchange servers.  I am going to configure my notification subscriptions so I can get an email anytime one of my Exchange servers has an issue. Try #1:  I start…

19

How do I delete an attribute in OpsMgr 2007?

I notice – when viewing a custom attribute, there is no option to delete it… only view the properties? Apparently this is by design.  There is no harm in having “extra” attributes in SCOM – that arent used.  However, if you do want to delete an unused attribute – you will have to export your…

0

MOM 2005 SP1 – upgrading SQL server from 2000 to 2005

  Upgrading from SQL 2000 to SQL 2005 to support MOM 2005 SP1: 1. Backup your MOM SQL server databases (OnePoint and Systemcenterreporting). Backup your Microsoft SQL Server Reporting Services databases. 2. Backup the SRS encryption key. 3. Stop the MOM Service on all management servers. 4. Upgrade the database servers and reporting servers to…

0

Tired of your console throwing errors – or manually clearing your console cache?

You can tell the Ops console to clear the cache everytime you open it!  Just change your shortcut – and add the /clearcache parameter:  “C:\Program Files\System Center Operations Manager 2007\Microsoft.MOM.UI.Console.exe” /clearcache   Keep in mind – this is no longer recommended post SP1 RTM….. just when you are having a problem.  By using this setting on all…

4

Got links?

Links you say?     Main Opsmgr Microsoft site: http://www.microsoft.com/systemcenter/opsmgr/default.mspx   OpsMgr Documentation: http://technet.microsoft.com/en-us/opsmgr/bb498235.aspx   OpsMgr Online Help: http://technet.microsoft.com/en-us/library/bb310604.aspx   Management Pack Catalog: http://www.microsoft.com/technet/prodtechnol/scp/catalog.aspx   OpsMgr TechCenter: http://technet.microsoft.com/en-us/opsmgr/default.aspx   Virtual Hands On Labs: http://technet.microsoft.com/en-us/bb539977.aspx   OpsMgr training videos and demos: http://technet.microsoft.com/en-us/opsmgr/bb498237.aspx   On Demand Webcasts: http://www.microsoft.com/events/series/technetmms.aspx?tab=webcasts&id=42365   OpsMgr Resource Kit: http://technet.microsoft.com/en-us/opsmgr/bb625978.aspx   OpsMgr SDK: http://msdn2.microsoft.com/en-us/library/bb437575.aspx…

0

How do I collect data from a multi-instance object – like a SQL DB instance?

How do I collect data from a multi-instance object – like a SQL DB instance?   This was a common question in the RTM version of the product.    If I wrote a rule to collect performance data against a SQL DB engine – I needed to specify the “instance” name.   The most common approach,…

0

Moving the Data Warehouse and ACS databases in OpsMgr 2007

Moving the Data Warehouse and ACS databases in OpsMgr 2007   Instructions for how to move the data warehouse database, and ACS database – have been published.   The Operations Manager 2007 Backup and Recovery Guide has been updated as of December 2007, to include moving the DW and ACS DB’s, in addition to the…

3

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…

22

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…

15

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: http://blogs.technet.com/momteam/archive/2007/12/10/how-does-computer-discovery-work-in-opsmgr-2007.aspx   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…

32

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…

8

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$…

61

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:  http://blogs.msdn.com/boris_yanushpolsky/archive/2007/08/02/enabling-proxying-for-agents.aspx Command line tool: …

4

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’,…

2