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.

  1. […] classic” Configuration Manager Dashboard that I have blogged about before, here and here, together with Orchestrator as a connector. We also created a small database in the middle. The […]

  2. […] The System Center Configuration Manager 2007 Dashboard with Operations Manager […]

  3. I have not played to much with that, sorry, try post the question on the Technet forum.

  4. Dominique says:

    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

  5. Hi, I guess you could re-built it a number of different ways. That is not something I have been looking at. Sorry.

  6. Dominique says:

    Hello,

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

    Thanks,
    Dom

  7. […] in the management group SELECT COUNT(*) AS NumManagedComps FROM ( SELECT bme2.BaseManagedEntityID Read More RECOMMENDED BOOKS REVIEWS AND OPINIONS Mastering System Center […]

  8. […] 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). […]

  9. […] Anders Bengtsson on The System Center Configuration Manager 2007 Dashboard with Operations Manager […]