Back at MMS this year we presented a session on authoring reports. During that session my colleague Vitaly created a SQL stored procedure that allowed us to create a server overview report showing key server metrics such as Processor Count, Physical Memory, CPU Utilization, Availability and Logical Disk Space. I have now eventually gotten round to making this report available in sample (non-production J ) form so you can see the approach we took.
This is a useful report as it draws server information from multiple data sources in the DW and presents them in a clear tabular form. It also enumerates all logical disks and presents their storage usage:
The report and the relevant stored procedures that it uses are in the Sample MP attached. Simply import and give it a go. Requires R2 RTM.
This report takes group as a parameter and I also wanted to share this query as I have been asked about it several times. This returns a list of all groups similar to what you would see in the groups tab under authoring in the console.
SELECT DisplayName FROM vManagedEntity
Where ManagedEntityTypeRowID in (
SELECT ManagedEntityTypeRowID from dbo.ManagedEntityDerivedTypeHierarchy
((
SELECT ManagedEntityTypeRowId from vmanagedentitytype
Where managedentitytypesystemname = 'system.group'),0))
ORDER BY DisplayName
Lastly there is a second report in the Sample MP that allows you to view alerts generated by a particular MP:
This posting is provided "AS IS" with no warranties, and confers no rights.Use of included utilities are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm
Daniel Savage
Please take the opportunity to participate in the SQL MP survey to help the SQL team build a better MP.
https://connect.microsoft.com/OpsMgr/Survey/Survey.aspx?SurveyID=9559
Thanks,
Justin
Operations Manager 2007 was one of the first products from Microsoft to ship with PowerShell capabilities out of the box. The Operations Manager Command Shell, which is an optional component of the UI installation, includes a snap-in containing 80+ OpsMgr specific cmdlets and a navigational provider which lets users traverse through the OM instance space like a directory.
We're looking for feedback from all OpsMgr 2007 (RTM, SP1 and R2) users on if and how you use PowerShell (both in general and specifically the Operations Manager Command Shell). If you don't use it then we'd like to hear that too. To that end we've posted a quick 10 question survey on our new Connect site (http://connect.microsoft.com/OpsMgr).
The survey is entirely anonymous and all you need to access the survey is a valid Live ID. Your feedback is greatly appreciated and will shape our future plans for PowerShell functionality in OpsMgr!
ThanksCory Delamarter
Support is now available for running Operations Manager 2007 SP1 and Operations Manager 2007 R2 on the following operating systems:
· Windows Server 2008 R2
· Windows 7
The official support statement is posted under Knowledge Base article 974722. The supported configuration guides for R2 and SP1 will be updated shortly as well. The following table lists the Operations Manager roles and components that are supported on these operating systems.
OS
OpsMgr server roles
OpsMgr Agent
OpsMgr Operations Console
Windows Server 2008 R2
Yes
Windows 7
No
The updated Windows Server Operating System Management Pack (version 6.0.6667.0), which includes support for Windows Server 2008 R2, is available on the System Center Operations Manager 2007 Catalog web site at this time as well! There are currently over 20 MP updates or new releases that are in the pipeline for months ahead to support this OS and when those management packs become available you can get them on the System Center Operations Manager 2007 Catalog web site and from the Operations Manager 2007 R2 Operations console.
Note: No support for Windows Server 2008 R2 or Windows 7 will be provided with Microsoft Operations Manager 2005.
Operations Manager 2007 R2 now officially supports the agent on Windows Embedded Standard 2009. You can download the latest “System Center Operations Manager 2007 R2 Agent Prerequisites Macro for Windows Embedded Standard 2009 (x86) - (English)”, is now live on subscriber downloads. You can download it at: http://msdn.microsoft.com/subscriptions/downloads
Overview
With the OpsMgr 2007 R2 Agent, you can monitor the health of the Windows Embedded operating system. These devices include, but are not restricted to, point of sale (POS) terminals, automated teller machines (ATMs) and Windows-based thin clients. Purpose Windows Embedded is the operating system and development platform that delivers the power of Windows in a componentized form for reliable and advanced embedded devices. Based on Windows Professional technology, Windows Embedded enables developers to select only the features they need to build customized, reduced-footprint software for embedded devices. The OpsMgr 2007 R2 Agent Prerequisite Component for Windows Embedded installs the necessary components that support the OpsMgr 2007 R2 Agent on Windows Embedded. This allows you to then install the OpsMgr 2007 R2 Agent and monitor the health of Windows Embedded in the same way as you monitor the health of other Microsoft operating systems. Download Contents When installed on the machine running the Target Designer, the OpsMgr 2007 R2 Agent Prerequisite Component adds the necessary Windows Embedded components to your Component Database. After you have installed an image created with this component, you will need to deploy the OpsMgr 2007 R2 Agent separately.
System Requirements
· Supported Operating Systems: Windows XP Embedded, Windows Embedded Standard 2009
This package requires a system that has Target Designer installed
Satya Vel