This post is part of a series where we will be using the Log Analytics workspace to store Office 365 information which will then be used to create a dashboard. We will first create the Log Analytics workspace in Azure, then create an app registration in Azure Active Directory, then a Runbook using Automation Accounts to upload data to the Log Analytics workspace and lastly we will be building a dashboard in the Log Analytics workspace.

The following posts are part of these series:

Log Analytics dashboard designer

Log Analytics dashboards can visualize all of your saved log queries, giving you the ability to find, correlate, and share IT operational data in the organization. This tutorial covers creating a log query that will be used to support a shared dashboard that will be accessed by your IT operations support team. You learn how to:

  • Create a shared dashboard in the Azure portal
  • Visualize a performance log query
  • Add a log query to a shared dashboard
  • Customize a tile in a shared dashboard

Building your first dashboard part

Go to the Log Analytics workspace

image_thumb[3]

Go to ‘View Designer’

image

Select Donut and fill in the following query

O365Status_CL | summarize arg_max(TimeGenerated, *) by Id_s | project-rename Service = Id_s, Status = Status_s | extend StatusId = case(Status == “ServiceOperational”, 0, Status == “ServiceDegradation”, 2, 1) | order by StatusId desc | project WorkloadDisplayName_s, Status, StatusId | summarize count() by Status | order by Status desc

Scroll down to change the colours

image

Then change to ‘View dashboard’

image_thumb[1]

We first going to visualize the Office 365 tenant status so we are going to use the Donut & Tile.
We are going to use the following Donut query to visualize the amount of the last data upload.

O365Status_CL | summarize arg_max(TimeGenerated, *) by Id_s | project-rename Service = Id_s, Status = Status_s | extend StatusId = case(Status == “ServiceOperational”, 0, Status == “ServiceDegradation”, 2, 1) | order by StatusId desc | project WorkloadDisplayName_s, Status, StatusId | summarize count() by Status | order by Status desc

image_thumb[5]

Scroll down so we can select our colors

image_thumb[8]

Scroll down to fill our list where we going to use the following query.

O365Status_CL | summarize arg_max(TimeGenerated, *) by Id_s | project-rename Service = Id_s, Status = Status_s | extend StatusId = case(Status == “ServiceOperational”, 0, Status == “ServiceDegradation”, 2, 1) | order by StatusId desc | project WorkloadDisplayName_s, Status, StatusId

image_thumb[10]

Building your second dashboard part

image_thumb[12]

We are going to use the Line chart

image

Start editing this dashboard part.
We are going to use the following line chart query to visualize the amount of the last data upload.

O365Subscriptions_CL | where skuPartNumber_s == “STANDARDPACK” | project consumedUnits_d , TimeGenerated | order by TimeGenerated desc

image

Scroll down to fill our list where we going to use the following query.

O365Subscriptions_CL | where skuPartNumber_s != “FLOW_FREE” | where capabilityStatus_s != “Suspended”  | summarize arg_max(TimeGenerated, *) by id_s | project skuPartNumber_s, consumedUnits_d

image

You can now continue editing the dashboard

image

Leave a Reply

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.