[OpsMgr 2007 R7] Cumulative Update 7 for System Center Operations Manager 2007 R2

I'm back after 15 days off with some updates ! :)

Cumulative Update 7 for System Center Operations Manager 2007 R2 has been released by Microsoft !

Cumulative Update 7 contains a number of fixes for Operations Manager 2007 R2, as well as all of the fixes from Operations Manager 2007 R2 CU6. A number of fixes may require manual steps to install.

Read more directly on http://support.microsoft.com/kb/2783850

Issues that are fixed in Cumulative Update 7

Cumulative Update 7 for System Center Operations Manager 2007 R2 fixes the following issues:

• Console performs poorly when User Roles are used to scope object access.
• Availability data is not shown for the current day when daily aggregation is used.
• Behavior is inconsistent between some views on web console and console.
• Log files do not roll over when the Unicode log file is monitored.
• Several security issues are fixed.

Cumulative Update 7 for System Center Operations Manager 2007 R2 fixes the following cross-platform issues:

• Logical disk performance statistics are not collected for some volume types on Solaris computers.
• Some Network Adapters on HP-UX computers may not be discovered.
• Network adapter performance statistics are not collected for HP-UX network adapters.
• The Solaris 8 and 9 agent may not restart after an ungraceful shutdown. 

How to obtain and install Cumulative Update 7 for System Center Operations Manager 2007 R2

Download information

Cumulative Update 7 for System Center Operations Manager 2007 R2 is available for download from the Microsoft Download Center.

Collapse this imageExpand this image

 

Download the Cumulative Update 7 package now.

 

File name	Size
SystemCenterOperationsManager2007-R2CU7- KB2783850-X86-X64-IA64-ENU.MSI	996.1 MB	Download

 

 

 

This posting is provided "AS IS" with no warranties.

Microsoft Tech Days 2012 - Webcats (Video in French)

One month ago 17,000 people were attended to the Microsoft's TechDays and Microsoft has released the slides and webcasts of all sessions.

System Center 2012 : Overview of the components of System Center 2012 and feedback from implementation in a company (SER208) 

System Center 2012 | SCCM: System Center Configuration Manager 2012 demo (CLI203)

System Center 2012 | SCOM: Overview of Operations Manager 2012

System Center 2012 | SCO: Overview of 2012 Orchestrator (formerly Opalis) (SER201)

System Center 2012 | SCCM : The inventory of A to Z with System Center Configuration Manager 2012 (CLI401)

System Center 2012 | SCO: Return of experiments and projects deployments System Center Opalis / Orchestrator (SER307)

See more video directly on the Microsoft site : http://www.microsoft.com/france/mstechdays

This posting is provided "AS IS" with no warranties.

[SQL & SCOM] List all Manual Reset Monitors

Here is a short SQL script to use to retrieve the Name of each Manual Reset Monitor. The aim was to identify these monitors in the connector.

1. Select Monitor.MonitorName, MNTSName
2. From [OperationsManager].[dbo].[MonitorTypeState] MTS
3. Inner join OperationsManager.dbo.MonitorType MT With (NOLOCK) on MT.MonitorTypeId = MTS. MonitorTypeId
4. Inner join Monitor with (NOLOCK) on Monitor. MonitorTypeId = MT. MonitorTypeId
5. Where MNTSName like '%ManualReset%'

Result should be like :

MonitorName	MNTSName
Microsoft.Windows.Server.2000.OperatingSystem.ServerServiceConfiguration	ManualResetEventRaised
Microsoft.Windows.Server.2003.OperatingSystem.ServerServiceConfiguration	ManualResetEventRaised
Microsoft.Windows.Server.2008.OperatingSystem.ServerServiceConfiguration	ManualResetEventRaised

This posting is provided "AS IS" with no warranties.

[SCOM 2007] Reducing calls to the Operations Database - Operation Manager Console Tuning

I've very slow performance with the Operation Manager Console and after some searches, I saw that we can change the default configuration of the automatic polling to the Opsmgr DB made by the console.

By default, the HKCU\Software\Microsoft\Microsoft Operations Manager\3.0\console\CacheParameters\PollingInterval registry key is set to 1 - That means that console will poll every 15 seconds the Operation Manager DB. If you use multiple consoles, that can negatively impact performance. 

For best performance in large environments, you should turn off Polling by setting the key to 0 or increase it to at least level 5. (level 10 is the maximum level value)

Here are the different value
                 0 – Turn off console polling and only refresh when manually pressing F5
                 1 – Console will poll every 15 seconds (default)
                 2 – Console will poll ever 30 seconds
               10 – This is the maximum value – anything above 10 will be treated as 10



NOTE: The CacheParameters key did not exist by default in my environment. HKCU\Software\Microsoft\Microsoft Operations Manager\3.0\console\CacheParameters\EnableContextMenuTasks
defaults value is 0 in SP1. Re-enabled it by recreating the key could cause performance issues.


Launch console on machine in good shape - I mean in good shape having a lot of free disk space not fragmented + at least 1 Go of free memory. The best should be to exclude the path to the console from the antivirus. The last thing should be to limit the number of open consoles.
Local console cache path is Documents and Settings\<username>\local settings\Application Data\Microsoft\Microsoft.MOM.UI.Console

This posting is provided "AS IS" with no warranties.

[SQL & SCOM] List SCOM groups for a list of servers

SELECT TargetMonitoringObjectDisplayName, SourceMonitoringObjectDisplayName AS 'Group'
FROM RelationshipGenericView
WHERE TargetMonitoringObjectDisplayName in ('MyServerFullName',
'MyServerFullName1')
AND (SourceMonitoringObjectDisplayName IN
(SELECT ManagedEntityGenericView.DisplayName
FROM ManagedEntityGenericView INNER JOIN
(SELECT BaseManagedEntityId
FROM BaseManagedEntity WITH (NOLOCK)
WHERE (BaseManagedEntityId = TopLevelHostEntityId) AND (BaseManagedEntityId NOT IN
(SELECT R.TargetEntityId
FROM Relationship AS R WITH (NOLOCK) INNER JOIN
dbo.fn_ContainmentRelationshipTypes() AS CRT ON R.RelationshipTypeId = CRT.RelationshipTypeId
WHERE (R.IsDeleted = 0)))) AS GetTopLevelEntities ON
GetTopLevelEntities.BaseManagedEntityId = ManagedEntityGenericView.Id INNER JOIN
(SELECT DISTINCT BaseManagedEntityId
FROM TypedManagedEntity WITH (NOLOCK)
WHERE (ManagedTypeId IN
(SELECT DerivedManagedTypeId
FROM dbo.fn_DerivedManagedTypes(dbo.fn_ManagedTypeId_Group()) AS fn_DerivedManagedTypes_1))) AS GetOnlyGroups ON
GetOnlyGroups.BaseManagedEntityId = ManagedEntityGenericView.Id))
ORDER BY 'Group'

Result will be like :

TargetMonitoringObjectDisplayName	Group
MyServerFullName1	agent group
MyServerFullName	agent group
MyServerFullName1	Agent Managed Computer Group
MyServerFullName	Agent Managed Computer Group
MyServerFullName1	All Windows Computers
MyServerFullName	All Windows Computers
MyServerFullName1	IIS 2003 Computer Group
MyServerFullName	IIS 2003 Computer Group
MyServerFullName1	IIS Computer Group
MyServerFullName	IIS Computer Group
MyServerFullName1	Windows Server 2003 Computer Group
MyServerFullName	Windows Server 2003 Computer Group
MyServerFullName1	Windows Server Computer Group
MyServerFullName	Windows Server Computer Group
MyServerFullName1	Windows Server Instances Group
MyServerFullName	Windows Server Instances Group

This posting is provided "AS IS" with no warranties.

System Center Operations Manager 2007 usefull SQL Queries

I will try to often update this post with the SQLqueries I've found or developped for specific report needs.

Last update : 2012/03/07

• Retrieve discovered objects for a specific class
• List SCOM groups for a list of servers
• Get SCOM Groups members using a SQL Query on OperationsManager DB
• List all Manual Reset Monitors

This posting is provided "AS IS" with no warranties.

[SQL & SCOM] Retrieve discovered inventory for a class from OperationManager DB

Retrieve table used (and view) used to store the informations for your class

select TypeName, ManagedTypeTableName, ManagedTypeViewName, IsDeleted  from ManagedType
where TypeName LIKE 'MyClassName'

Result will be like :

TypeName	ManagedTypeTableName	ManagedTypeViewName	IsDeleted
MyClassName	MT_CLS1_O	MTV_CLS1_N	0

Discovered inventory can be also retrieved by using the view :

select * from MTV_CLS1_N

This posting is provided "AS IS" with no warranties.