{"id":4576,"date":"2019-07-25T11:54:07","date_gmt":"2019-07-25T09:54:07","guid":{"rendered":"http:\/\/contoso.se\/blog\/?p=4576"},"modified":"2020-04-29T13:07:34","modified_gmt":"2020-04-29T11:07:34","slug":"visualize-alerts-on-azure-dashboard","status":"publish","type":"post","link":"http:\/\/contoso.se\/blog\/?p=4576","title":{"rendered":"Visualize alerts on Azure dashboard [updated]"},"content":{"rendered":"\n<p>A common ask is how to visualize alerts from Azure Monitor on an Azure dashboard. Publishing data, including alerts, from Azure Monitor, can be accomplished with a workbook.  <br \/><br \/>With Azure Monitor workbooks, we can create interactive reports based on collected data. Read more about Workbooks at <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-monitor\/app\/usage-workbooks\">Microsoft Docs<\/a>.<br \/><br \/>In this example, we visualize new active alerts on an Azure Dashboard. We start with an empty workbook and add a query tile.  <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-11.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" width=\"602\" height=\"356\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-11.png\" alt=\"\" class=\"wp-image-4577\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-11.png 602w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-11-300x177.png 300w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-11-552x326.png 552w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>Configure the query, note that we use Alerts as data source and no summary of the result. We have also configured the query to show only New Fired alerts. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-12.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" width=\"602\" height=\"55\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-12.png\" alt=\"\" class=\"wp-image-4578\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-12.png 602w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-12-300x27.png 300w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-12-552x50.png 552w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>Use Column Settings to hide columns that should not be displayed.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-13.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" width=\"433\" height=\"579\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-13.png\" alt=\"\" class=\"wp-image-4579\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-13.png 433w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-13-224x300.png 224w\" sizes=\"(max-width: 433px) 100vw, 433px\" \/><\/a><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-14.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" width=\"602\" height=\"297\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-14.png\" alt=\"\" class=\"wp-image-4580\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-14.png 602w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-14-300x148.png 300w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-14-552x272.png 552w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>Once we are happy with the look of the result, we can click PIN, and pin the panel to a dashboard. When in Edit mode of a tile, we can pin that specific tile. We can also use pin in the top toolbar to pin all parts of a workbook to a dashboard. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-15.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" width=\"602\" height=\"423\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-15.png\" alt=\"\" class=\"wp-image-4581\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-15.png 602w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-15-300x211.png 300w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2019\/07\/image-15-552x388.png 552w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/a><\/figure><\/div>\n\n\n\n<p><strong>UPDATE<\/strong><\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>The suggested way to query for Azure Alert information is by using the * Azure Resource Graph data source, by querying the AlertsManagementResources table. See Azure Resource Graph table reference Azure Docs, or the Alerts template for examples. The Alerts data source will remain available for a period of time while authors transition to using ARG. Use of this data source in templates is discouraged.<\/p><cite>See more at <a href=\"https:\/\/github.com\/microsoft\/Application-Insights-Workbooks\/blob\/master\/Documentation\/DataSources\/DataSources.md#alerts-preview\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Docs<\/a><\/cite><\/blockquote>\n\n\n\n<p>Based on this new recommendation we should re-configure our workbook to use Azure Resource Graph as data source. <\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" width=\"667\" height=\"446\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image.png\" alt=\"\" class=\"wp-image-4675\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image.png 667w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-300x201.png 300w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-75x50.png 75w\" sizes=\"(max-width: 667px) 100vw, 667px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>The query also needs to be a bit updated, as the image below. It is still the Kusto language, but the syntax is a bit different. To learn more about writing queries in Azure Resource Graph, see <a rel=\"noreferrer noopener\" target=\"_blank\" href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/governance\/resource-graph\/samples\/starter?tabs=azure-cli\">Microsoft Docs<\/a>. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"396\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-1-1024x396.png\" alt=\"\" class=\"wp-image-4677\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-1-1024x396.png 1024w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-1-300x116.png 300w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-1-768x297.png 768w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-1.png 1219w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Columns can be renamed by using the column settings feature, see images below. Under column settings, you can also re-format date and configure thresholds on the severity, for example, a red warning sign for severity 0 alerts.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"289\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-2-1024x289.png\" alt=\"\" class=\"wp-image-4678\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-2-1024x289.png 1024w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-2-300x85.png 300w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-2-768x217.png 768w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-2.png 1350w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-3.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" width=\"520\" height=\"615\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-3.png\" alt=\"\" class=\"wp-image-4679\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-3.png 520w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-3-254x300.png 254w\" sizes=\"(max-width: 520px) 100vw, 520px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img decoding=\"async\" loading=\"lazy\" width=\"515\" height=\"520\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-4.png\" alt=\"\" class=\"wp-image-4680\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-4.png 515w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-4-297x300.png 297w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2020\/04\/image-4-150x150.png 150w\" sizes=\"(max-width: 515px) 100vw, 515px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>A common ask is how to visualize alerts from Azure Monitor on an Azure dashboard. Publishing data, including alerts, from Azure Monitor, can be accomplished with a workbook. With Azure Monitor workbooks, we can create interactive reports based on collected data. Read more about Workbooks at Microsoft Docs. In this example, we visualize new active &hellip; <a href=\"http:\/\/contoso.se\/blog\/?p=4576\">Continue reading <span class=\"meta-nav\">&rarr;<\/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":[64,75],"tags":[],"_links":{"self":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4576"}],"collection":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4576"}],"version-history":[{"count":3,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4576\/revisions"}],"predecessor-version":[{"id":4681,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4576\/revisions\/4681"}],"wp:attachment":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4576"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}