{"id":1357,"date":"2010-03-08T09:04:21","date_gmt":"2010-03-08T07:04:21","guid":{"rendered":"http:\/\/contoso.se\/blog\/?p=1357"},"modified":"2010-03-08T09:06:55","modified_gmt":"2010-03-08T07:06:55","slug":"investigate-most-common-alert","status":"publish","type":"post","link":"https:\/\/contoso.se\/blog\/?p=1357","title":{"rendered":"Investigate most common alert"},"content":{"rendered":"

The following SQL queries can be used to first\u00c2\u00a0list which machine or\u00c2\u00a0path and then\u00c2\u00a0rules or monitors that generate most alerts in your environment. The first query will show you which computer or path that generate most alerts. The second query will show you which rule or monitor that generate most alerts on one singel machine or path. Run both queries against your data warehouse database (OperationsManagerDW).<\/p>\n

\"\"<\/a><\/div>\n

\u00c2\u00a0<\/p>\n

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

All Path
\nSELECT
\nvManagedEntity.Path, COUNT(1) AS pathcount<\/code><\/div>\n
FROM Alert.vAlertDetail INNER JOIN
\nAlert.vAlert ON Alert.vAlertDetail.AlertGuid = Alert.vAlert.AlertGuid INNER JOIN
\nvManagedEntity ON Alert.vAlert.ManagedEntityRowId =
\nvManagedEntity.ManagedEntityRowId
\nGROUP BY vManagedEntity.Path
\nORDER BY pathcount DESC<\/code><\/div>\n
\u00c2\u00a0<\/code><\/div>\n
\u00c2\u00a0<\/code><\/div>\n

\u00c2\u00a0<\/p>\n

<\/code><\/p>\n

One Path
\nSELECT
\nAlert.vAlert.AlertName,
\nAlert.vAlert.AlertDescription,
\nvManagedEntity.Path, COUNT(1) AS alertcount
\nFROM Alert.vAlertDetail INNER JOIN
\nAlert.vAlert ON Alert.vAlertDetail.AlertGuid = Alert.vAlert.AlertGuid INNER JOIN
\nvManagedEntity ON Alert.vAlert.ManagedEntityRowId =
\nvManagedEntity.ManagedEntityRowId<\/code><\/div>\n
WHERE Path = 'opsmgr29.hq.contoso.local'
\nGROUP BY Alert.vAlert.AlertName, Alert.vAlert.AlertDescription, vManagedEntity.Path
\nORDER BY alertcount DESC<\/code><\/div>\n
<\/div>\n
<\/code><\/div>\n

You could also use these queries in a report, take a look at this<\/a> post about author custom reports.<\/p>\n","protected":false},"excerpt":{"rendered":"

The following SQL queries can be used to first\u00c2\u00a0list which machine or\u00c2\u00a0path and then\u00c2\u00a0rules or monitors that generate most alerts in your environment. The first query will show you which computer or path that generate most alerts. The second query will show you which rule or monitor that generate most alerts on one singel machine … 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":[13,19],"tags":[],"_links":{"self":[{"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1357"}],"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=1357"}],"version-history":[{"count":7,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1357\/revisions"}],"predecessor-version":[{"id":1365,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1357\/revisions\/1365"}],"wp:attachment":[{"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1357"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}