{"id":1409,"date":"2010-03-12T21:38:46","date_gmt":"2010-03-12T19:38:46","guid":{"rendered":"http:\/\/contoso.se\/blog\/?p=1409"},"modified":"2010-03-12T21:40:29","modified_gmt":"2010-03-12T19:40:29","slug":"sccm-dashboard-with-ops-mgr","status":"publish","type":"post","link":"https:\/\/contoso.se\/blog\/?p=1409","title":{"rendered":"The System Center Configuration Manager 2007 Dashboard with Operations Manager"},"content":{"rendered":"

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.\u00c2\u00a0More info about the dashboard at the System Center Team Blog<\/a>. Timothy McFadden posted a good post<\/a> about how to use this dashboard with Operations Manager 2007 R2. I have tried this in my sandbox and it works really good.<\/p>\n

\"\"<\/a><\/p>\n

Here are some example queries to use<\/p>\n

Total number of computers in the management group<\/p>\n

SELECT COUNT(*) AS NumManagedComps FROM (
\nSELECT bme2.BaseManagedEntityID
\nFROM BaseManagedEntity bme WITH (NOLOCK)
\nINNER JOIN BaseManagedEntity bme2 WITH (NOLOCK) ON bme2.BaseManagedEntityID = bme.TopLevelHostEntityID
\nWHERE bme2.IsDeleted = 0
\nAND bme2.IsDeleted = 0
\nAND bme2.BaseManagedTypeID = (SELECT TOP 1 ManagedTypeID FROM ManagedType WHERE TypeName = ‘microsoft.windows.computer’)
\nGROUP BY bme2.BaseManagedEntityID
\n) AS Comps<\/p><\/blockquote>\n

Number of new active alerts<\/p>\n

SELECT COUNT(1) AS ActiveAlerts FROM Alert WHERE ResolutionState = ‘0’<\/p><\/blockquote>\n

Health State summary of all Windows Computers based<\/p>\n

SELECT [State] = CASE ManagedEntityGenericView.HealthState
\nWHEN 1 THEN ‘Healthy’
\nWHEN 2 THEN ‘Warning’
\nWHEN 3 THEN ‘Critical’
\nELSE ‘Unknown’
\nEND
\n, COUNT(1) AS GroupCount<\/p>\n

FROM ManagedEntityGenericView INNER JOIN
\nManagedTypeView ON ManagedEntityGenericView.MonitoringClassId = ManagedTypeView.Id
\nWHERE (ManagedTypeView.Name LIKE ‘Microsoft.Windows.Computer’)
\nGROUP BY ManagedEntityGenericView.HealthState
\nORDER BY GroupCount<\/p><\/blockquote>\n

Top 10 alerts<\/p>\n

SELECT TOP 10 SUM(1) AS AlertCount, AlertStringName
\nFROM Alertview WITH (NOLOCK)
\nWHERE TimeRaised is not NULL
\nGROUP BY AlertStringName, AlertStringDescription, MonitoringRuleId, Name
\nORDER BY AlertCount DESC<\/p><\/blockquote>\n

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<\/p>\n

\"\"<\/a><\/p>\n

Thanks to my colleague Ola Ahrens for SQL support.<\/p>\n","protected":false},"excerpt":{"rendered":"

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.\u00c2\u00a0More 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 … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[19],"tags":[],"_links":{"self":[{"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1409"}],"collection":[{"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1409"}],"version-history":[{"count":6,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1409\/revisions"}],"predecessor-version":[{"id":1417,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1409\/revisions\/1417"}],"wp:attachment":[{"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}