Home » System Center Operations Manager 2007 » The System Center Configuration Manager 2007 Dashboard with Operations Manager

The System Center Configuration Manager 2007 Dashboard with Operations Manager

By in System Center Operations Manager 2007 on .

The System Center Configuration Manager 2007 Dashboard can show you a web based status report, including system deployments, security updates, system health status and more for your Configuration Manager environment. More info about the dashboard at the System Center Team Blog. Timothy McFadden posted a good post about how to use this dashboard with Operations Manager 2007 R2. I have tried this in my sandbox and it works really good.

Here are some example queries to use

Total number of computers in the management group

SELECT COUNT(*) AS NumManagedComps FROM (
SELECT bme2.BaseManagedEntityID
FROM BaseManagedEntity bme WITH (NOLOCK)
INNER JOIN BaseManagedEntity bme2 WITH (NOLOCK) ON bme2.BaseManagedEntityID = bme.TopLevelHostEntityID
WHERE bme2.IsDeleted = 0
AND bme2.IsDeleted = 0
AND bme2.BaseManagedTypeID = (SELECT TOP 1 ManagedTypeID FROM ManagedType WHERE TypeName = ‘microsoft.windows.computer’)
GROUP BY bme2.BaseManagedEntityID
) AS Comps

Number of new active alerts

SELECT COUNT(1) AS ActiveAlerts FROM Alert WHERE ResolutionState = ‘0’

Health State summary of all Windows Computers based

SELECT [State] = CASE ManagedEntityGenericView.HealthState
WHEN 1 THEN ‘Healthy’
WHEN 2 THEN ‘Warning’
WHEN 3 THEN ‘Critical’
ELSE ‘Unknown’
END
, COUNT(1) AS GroupCount

FROM ManagedEntityGenericView INNER JOIN
ManagedTypeView ON ManagedEntityGenericView.MonitoringClassId = ManagedTypeView.Id
WHERE (ManagedTypeView.Name LIKE ‘Microsoft.Windows.Computer’)
GROUP BY ManagedEntityGenericView.HealthState
ORDER BY GroupCount

Top 10 alerts

SELECT TOP 10 SUM(1) AS AlertCount, AlertStringName
FROM Alertview WITH (NOLOCK)
WHERE TimeRaised is not NULL
GROUP BY AlertStringName, AlertStringDescription, MonitoringRuleId, Name
ORDER BY AlertCount DESC

If you would like to replace the banner you will find it in C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\IMAGES\Microsoft.DashboardFramework. One idea for a new banner could be

Thanks to my colleague Ola Ahrens for SQL support.

15 Comments

  2. I am trying to pull report for installed applications with Installed date in Add\Remove in SCCM 2007, I get date for all other applications but for office 365 ProPlus I don’t get a date.
    Any help is appreciated.

    Rasiq

  10. Hello,
    another question, is it possible to remove the .000 in the Gauge counter?

    The computers count is 656.000 when I have 656 servers… I know it is cosmetic but sorry to ask I have it in my plate ….

    Thanks,
    Dom

  12. Hello,

    Excellent !!!… No i am looking for cosmetics… 🙂
    Health State: will it be possible to have several colors?

    Thanks,
    Dom

  14. […] Posted by Daniele Grandini on April 21, 2010 The Solution Accelerators team recently released the Configuration Manager Dashboard (http://technet.microsoft.com/en-us/library/ff369719.aspx). The dashboard is a WSS 3.0 / MOSS 2007 solution that tries to give an high level graphical representation of the data contained in ConfigMgr. The dashboard solution is useful to give IT executives a understandable view of common ICT processes such as OS distribution, patching compliance, specific software distributions metrics. More, the dashboard is generic enough you can extract any kind of summary data from any kind of SQL database even from OpsMgr databases (check this post from my fellow MVP Anders http://contoso.se/blog/?p=1409). […]

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.