Don Hite at myITforum.com : OpsMgr 2007

Hiding Selected OpsMgr 2007 Console Views

dhite — Sun, 22 Jun 2008 18:03:03 GMT

Here you will find the steps necessary to hide selected OpsMgr console views. You can also use this procedure to show items that are not presently available.

1. Open the Operations Console.

2. Select "Monitoring" if it is not open.

3. Click on "Show or hide views..."

The Show or hide views dialog box will appear where you can check or uncheck the views that you want to be displayed or not be displayed in the console.

Note: You can also choose “Select All” or “Select None”.

The following views are available:

Agentless Exception Monitoring

Data Warehouse

Microsoft Audit Collection Services

Microsoft SQL Server

Microsoft System Center Configuration Manager 2007

Microsoft Windows Client

Network Device

Operations Manager

Synthetic Transaction

Web Application

VBS Script To Create A Local OpsMgr 2007 Installed Components XML File

dhite — Sun, 08 Jun 2008 13:29:11 GMT

This VBS Script will create an Xml reference file showing all of the installed components for the machine on which the script is executed on. For additional information on the CleanMom utility and where to download it from see my previous post below.

VBS Script:

strFileName = InputBox("Enter File Name")

'Don't Enter The .Xml File Extension As It Is Hard Coded.

Set WshShell = Wscript.CreateObject("Wscript.Shell")

Set objFSO = Wscript.CreateObject("Scripting.FileSystemObject")

'Change The Directory Folder Name As Needed:

strExeLocation = "C:\Folder_Name"

'CleanMom Static Vars - Do Not Change

strExecutable = "CleanMom.Exe"

strCommandLine = "/c /Xml"

strExtension = ".Xml"

objCommand = "Cmd /C" & Chr(32) & strExeLocation & "\" & strExecutable & _

Chr(32) & strCommandLine & Chr(32) & strFileName & strExtension

WshShell.Run(objCommand)

MsgBox "Done"

The OpsMgr 2007 Resource Kit Cleanup Tool

http://myitforum.com/cs2/blogs/dhite/archive/2008/06/01/the-opsmgr-2007-resource-kit-cleanup-tool.aspx

The OpsMgr 2007 Resource Kit Cleanup Tool

dhite — Sun, 01 Jun 2008 12:35:48 GMT

A command line tool is available to remove all of the installed components of an OpsMgr 2007 or SCE 2007 installation and is a part of the Operations Manager 2007 Resource Kit (OpsMgrCleanup.Zip) at the download link below.

The utility must be run locally as opposed to remotely. The tool not only rolls back the installation but also removes the associated registry keys, any installed services and all of the associated directory tree structures.

For 32 Bit Network Operating Systems (NOS) use CleanMom.Exe and for 64 bit NOS resources use CleanMom64.Exe both of which are included in the dowlaod.

Command Line Switches:

CleanMom.Exe /CleanAgents

Removes all agent components.

CleanMom.Exe /CleanServers

Removes all server components.

CleanMom.Exe /c

Creates an Xml reference file showing installed components.

CleanMom.Exe /a

Reads the XML file created using the /c switch above where you can select the components to remove.

Usage:

CleanMom.Exe /c /xml <XML File Name>

Will produce an inventory XML of all MOM components on this box

CleanMom.Exe /a /xml <XML File Name>

Will process an inventory XML of all MOM components on this box

CleanMom.Exe /CleanAgents

Will remove any MSI information for MOM Agents on this computer

CleanMom.Exe /CleanServers

Will remove any MSI information for MOM servers on this computer

Example:

CleanMom.Exe /c /xml "c:\temp folder\myxmlfile.xml"

This will scan the computer for any MOM components and output the results to "c:\temp folder\myxmlfile.xml". The user could then adjust the actions section and make the same call using /a instead of /c and the tool would perform the actions specified in the XML actions section of each product in the XML file.

Operations Manager Cleanup Tool

http://www.microsoft.com/downloads/details.aspx?FamilyId=14FF7073-C71B-4AD0-805A-A8E458D2C9E0&displaylang=en

SQL Query To Retrieve OpsMgr 2007 Machine Information

dhite — Mon, 26 May 2008 12:39:37 GMT

This SQL Query will return the following machine information from the OperationsManager database: Machine Name, Machine Fully Qualified Domain Name (FQDN), IP Address, Active Directory (AD) site, Organizational Unit (OU) name and if the machine is a virtual machine or not.

SQL Query:

Select

NetbiosComputerName 'Machine Name',

NetworkName FQDN,

IPAddress 'IP Address',

ActiveDirectorySite 'AD Site',

OrganizationalUnit 'OU Name',

'Virtual Machine' = Case

When IsVirtualMachine = 0 Then 'No'

Else 'Yes'

End

From Mt_Computer

Override Creator Connect To Root Management Server .NET Error

dhite — Sun, 18 May 2008 12:26:09 GMT

When you attempt to execute the Boris Yanushpolsky Override Creator (OverrideCreator.Exe) for OpsMgr 2007 you may receive the following error:

Connect to Root Management Server

Application attempted to perform an operation not allowed by the security policy. To grant this application the required permission, contact your system administrator, or use the Microsoft .NET Framework Configuration Tool.

That assembly does not allow partially trusted callers.

This error is generated because you attempted to run the application remotely. To resolve the issue run the application locally from the OpsMgr 2007 database server.

The Boris Yanushpolsky Override Creator

http://myitforum.com/cs2/blogs/dhite/archive/2007/08/19/the-boris-yanushpolsky-override-creator.aspx

Operations Manager 2007 SP 1 Upgrade

dhite — Sun, 11 May 2008 13:00:34 GMT

With the release of the Operations Manager 2007 Service Pack (SP) 1 Upgrade it is a must have just for the new features listed here:

Improved performance and reliability when working with alerts, overrides, and searches.

In all Alert views, performance has been increased through better fetching and yields alert row selection that is three times quicker. Actions and reports are fetched in the background, which further improves performance. Alert knowledge that is displayed in the Alert Details pane can be shown or hidden according to the user's preference.

Operations Manager 2007 advanced search has been improved by enabling the ability to search across monitors and rules by their overrides.

Support for the discovery and monitoring of both SNMP v1 and SNMP v2 network devices. Users can select which SNMP Version to search for in the Discovery Wizard.

Support for exporting Operations Manager 2007 diagrams to Microsoft Visio VDX file format. Note that the Visio button is located on the toolbar when in a diagram view. Diagram layouts can now be saved and will be remembered when the diagram view is selected again.

Support for copying and pasting (CTRL+C and CTRL+V) from the Alert details pane.

Added support for earlier versions of e-mail servers to correct an issue that might result in malformed data in subject line of e-mail notifications.

Operations Manager 2007 Service Pack 1 Upgrade Package

http://www.microsoft.com/downloads/details.aspx?FamilyID=ede38d83-32d1-46fb-8b6d-78fa1dcb3e85&DisplayLang=en

Operations Manager 2007 SP1 Upgrade Guide

http://technet.microsoft.com/en-us/library/bb822001.aspx

SQL Query To Retrieve Your OpsMgr 2007 Management And Admin Group Names

dhite — Sun, 04 May 2008 12:10:29 GMT

This SQL Query will retrieve your OpsMgr 2007 Management group and Admin group names for your reference.

SQL Query:

Select

ManagementGroupName 'Group Name',

MOMAdminGroup 'Admin Group'

From __MOMManagementGroupInfo__

Operations Manager 2007 Service Pack 1 Information Links

dhite — Sun, 20 Apr 2008 12:16:06 GMT

Here you will find Microsoft provided links to get the information you need prior to applying the Service Pack (SP) 1 upgrade.

Note: If you have the Operations Manager 2007 SP1 RC 1 installed you do not have to uninstall it prior to installing the final version.

Complete list of fixes and changes that are included in Operations Manager 2007 SP1

http://go.microsoft.com/fwlink/?LinkId=102042

Operations Manager 2007 SP1 Release Notes

http://technet.microsoft.com/en-us/library/cc296234.aspx

Operations Manager 2007 Quick Start Guide

http://technet.microsoft.com/en-us/library/bb418758.aspx

Operations Manager 2007 SP1 Supported Configurations

http://technet.microsoft.com/en-us/library/bb309428.aspx

Operations Manager 2007 Service Pack 1 Upgrade Guide

http://technet.microsoft.com/en-us/library/bb822001.aspx

Deployment Guide for Operations Manager 2007 Service Pack 1

http://download.microsoft.com/download/7/4/d/74deff5e-449f-4a6b-91dd-ffbc117869a2/OpsMgr2007_Deployment.doc

Operations Manager 2007 Service Pack 1 Upgrade Package

http://www.microsoft.com/downloads/details.aspx?FamilyID=ede38d83-32d1-46fb-8b6d-78fa1dcb3e85&DisplayLang=en

The Microsoft OpsMgr 2007 Service Pack 1 Resource Page

dhite — Sun, 09 Mar 2008 13:25:44 GMT

The Microsoft Operations Manager (OpsMgr) 2007 Service Pack (SP) 1 is now available for download after being released from Beta and can be downloaded from the link at the end of this post.

Microsoft is also committed to helping you get the most of SP 1 and has created a Microsoft Operations Manager Resource page which includes the following information.

Operations Manager 2007 Service Pack 1 (SP1)

http://technet.microsoft.com/en-us/opsmgr/cc280350.aspx

Things to know about Operations Manager 2007 Service Pack 1

Product Evaluation

What’s New in Operations Manager 2007 Service Pack 1

http://technet.microsoft.com/library/bb821996.aspx

Getting Started

Release Notes for Operations Manager Service Pack 1

http://technet.microsoft.com/library/cc296234

Quick Start

http://technet.microsoft.com/library/bb418758

Supported Configurations

http://technet.microsoft.com/library/bb309428.aspx

Deployment

Operations Manager 2007 Service Pack 1 Upgrade Guide

http://technet.microsoft.com/library/bb822001.aspx

Deployment Guide for Operations Manager 2007 Service Pack 1

http://download.microsoft.com/download/7/4/d/74deff5e-449f-4a6b-91dd-ffbc117869a2/OpsMgr2007_Deployment.doc

Extending Operations Manager 2007

Management Pack Authoring Guide

http://download.microsoft.com/download/7/4/d/74deff5e-449f-4a6b-91dd-ffbc117869a2/OM2007_AuthGuide.doc

Report Authoring Guide

http://download.microsoft.com/download/7/4/d/74deff5e-449f-4a6b-91dd-ffbc117869a2/OpsMgr2007_RprtGuide.doc

Related Resources

SP1 Training Videos

http://technet.microsoft.com/en-us/opsmgr/bb986763.aspx

Online Technical Library

http://technet.microsoft.com/library/bb310604

Modifying the Operations Manager 2007 Action Account

dhite — Sun, 02 Mar 2008 14:18:00 GMT

The Microsoft document linked below will provide you with the steps necessary to modify the OpsMgr action account after installation.

How to change the credentials for the OpsMgr SDK Service and for the OpsMgr Config Service in Microsoft System Center Operations Manager 2007

http://support.microsoft.com/default.aspx?scid=kb;EN-US;936220

The Boris Yanushpolsky MP Viewer Updated

dhite — Sun, 24 Feb 2008 20:57:30 GMT

Boris Yanushpolsky has released an update to his MP Viewer version 1.3 which is available from his Blog page. Updates include the following taken from his original post:

1 - The target of a rule/monitor

2 - The type of a monitor

3 - The priority of the alert generated by a monitor

4 - Whether a rule generates an alert as well as the severity and priority of the alert.

5 - Command line mode is now supported. So you can run it like this: C:\MPViewer.exe "C:\SampleMP.mp" "C:\SampleMPReport.html" (this can help create HTML reports for a large number of management packs without opening each one in the MPViewer UI).

MPViewer Version 1.3 Download

http://blogs.msdn.com/boris_yanushpolsky/attachment/7343239.ashx

Windows Vista Client Monitoring Management Pack for Operations Manager 2007

dhite — Sun, 10 Feb 2008 13:07:11 GMT

The Windows Vista Client Monitoring Management Pack monitors the health of Windows Vista clients and presents aggregate reports on client health.

Download:

http://www.microsoft.com/downloads/details.aspx?FamilyID=a2d42208-d4fd-46a6-9e8d-0ff7694b5634&displaylang=en

OpsMgr 2007 Machine Organizational Units SQL Query

dhite — Sun, 03 Feb 2008 14:20:34 GMT

Here you will find two SQL queries to list OpsMgr 2007 machine organizational units (OU’s) to the results pane. The first one allows you to see all of the OU’s for all of the machines in the database. The second one allows you to see the OU for a specified machine name.

List Machines And OU’s:

Select

NetbiosComputerName 'Machine Name',

OrganizationalUnit OU

From Mt_Computer

Order By 'Machine Name'

Get A Machines OU Name:

Select

OrganizationalUnit

From Mt_Computer

Where NetbiosComputerName = 'Machine_Name'

Viewing Resources In A Specific OpsMgr 2007 Management Group

dhite — Sun, 27 Jan 2008 18:55:57 GMT

Here you will find information on how to view or enumerate members of a specified OpsMgr 2007 management group.

Follow the steps below:

1. Open the Command Shell and issue a “Dir” command to list all of the available groups:

Dir | FL DisplayName, PathName

2. Next select one such as the “Root Management Server Computers Group”

3. Next change to the group root by issuing the CD command:

Cd Microsoft.SystemCenter.RootManagementServerComputersGroup

4. Then reissue the Dir command to list the resources in the group:

Dir | FL DisplayName, ManagementGroup, HealthState

Note: You can also issue just the Dir command and the following information will be displayed: Id, PathName, DisplayName, ManagementMode, ManagementGroup, HealthState and the OperationalState

OpsMgr 2007 Ports

dhite — Sun, 20 Jan 2008 14:35:40 GMT

Here you will find a listing of the Microsoft OpsMgr 2007 used Ports.

Name	TCP/IP Port
ACS forwarder to ACS collector	51909
Agent to Root Management Server	5723
Agent-less management	Uses RPC
Operations Console to Reporting Server	80
Operations Console to Root Management Server	5724
SQL Server 2005 (Default Instance)	1433
Web Console to Web Console server	51908, 445