Category Archives: Uncategorized

How to: Availability Workbook for Azure Monitor

Azure Monitor workbooks are very powerful and a great addition to the Monitor toolset you can learn more about them in my article here. Today we’ll be using Workbooks to create an availability report for our servers.

First we need our query, below is a fairly stock example of how to use the Heartbeat table to get the number of hours a server has been online and compare that to a set number of hours, in this case the past 7 days (168 hours) and work that out as a percentage.

let starttime=startofday(now()-7d);
let endtime=now();
Heartbeat
| where TimeGenerated >= starttime and TimeGenerated <= endtime
| summarize heartbeat_per_hour=count() by bin_at(TimeGenerated, 1h, starttime), Computer
| extend available_per_hour=iff(heartbeat_per_hour>0, true, false)
| summarize total_available_hours=countif(available_per_hour==true) by Computer
| extend total_number_of_buckets=round((endtime-starttime)/1h)
| extend availability_rate=total_available_hours*100/total_number_of_buckets

As you can see running this query against your Log Analytics workspace will return exactly that, The Computer name, the total number of hours or “buckets”, the number of available hours and the percentage or Availability rate.

Once we have a working query it’s time to create our workbook, this can be done under the Azure Monitor blade of the Azure console, simple click on Workbooks which is still in preview and then click new.

Click add query and configure your workspace as shown below, then click Run Query

So far so good, now we want to be able to select the time range for our availability report. to do this click add Parameters at the bottom of the editor. Conveniently there is a pre-built parameter called Time range picker so we’ll use that. Make sure you tick required to make this mandatory for the Workbook.

Save your new parameter and then click the up arrow to move this section to the top of the page.

Now our query needs a slight adjustment to be able to use the time picker, below you can see I’ve created variables for the time ranges and substituted them into my query in the relevant locations.

let timeRangeStart = {TimeRange:start};
let timeRangeEnd = {TimeRange:end};
Heartbeat
| where TimeGenerated >= timeRangeStart and TimeGenerated <= timeRangeEnd
| summarize heartbeat_per_hour=count() by bin_at(TimeGenerated, 1h, timeRangeStart), Computer
| extend available_per_hour=iff(heartbeat_per_hour>0, true, false)
| summarize total_available_hours=countif(available_per_hour==true) by Computer
| extend total_number_of_buckets=round((timeRangeEnd-timeRangeStart)/1h)
| extend availability_rate=total_available_hours*100/total_number_of_buckets

Lastly we want to add a bit of colour to the report, a nice way to do this is to click on the Column Settings button, select availability rate and configure it to display as a bar. Making the colour palette Red to Green also means that the higher the number the more green the bar becomes allowing servers with poor availability to stand out.

Click save and there you have it a Server Availability Workbook for Azure Monitor. Save this workbook and you can access it from the workbook gallery and also pin it to an existing Azure Dashboard.

Management Pack Recap – May 2019 Wave

This is a summary of the wave of Management Packs that were released in May 2019. Information and download location in the links provided:

Lenovo Hardware Management Pack v7.6.0.8here

If you know of any other Management Packs that have been released recently that I may have missed leave me a note in the comments and I’ll add them

Create interactive reports with Azure Monitor workbooks

A new feature in Azure, Workbooks combine text, Analytics queries, Azure Metrics, and parameters into rich interactive reports. 

For those of your familiar with SCOM, think of workbooks as a pre-bundled set of metrics similar to the dashboards you are already familiar with. It offers a simple method to share useful dashboards which can also be copied and exported.

Let’s dive right in.

So how do I find them?

Simply navigate to Monitor in the Azure portal and click on Workbooks, currently in preview at the time of this article.

Whats available currently?

There are several pre-build templates out of the box as well as a GIT available as a repository for additional templates.

VM Metrics Example

Below are several sample outputs of the various workbooks, not only do they look good but they also contain rich useful information on every object in your subscription that is metric enabled.

Management Pack Recap – January 2019 Wave

This is a summary of the wave of Management Packs that were released in January 2019. Information and download location in the links provided:

SSRS2017+ MP now with Power BI Reporting v7.0.12.0here

Sharepoint 2019 MP v16.0.11308.30000here

If you know of any other Management Packs that have been released recently that I may have missed leave me a note in the comments and I’ll add them

SCOM: Updated Windows Server 2016 and 1709+ DNS Monitoring MP v10.0.9.2

A new version of the Windows server 2016 and DNS 1706+ Mp is available get it here

Fixed in this version

• Fixed bug: Problem with DNS Zones Discovery for large number of zones.
• Fixed bug: Problem with stub zones discovery.
• Fixed bug: False alerts for “DNS unused Zone Detected”.
• Introduced support for Windows Server 1709+ operating system.
• Rebranded the display strings and knowledge base articles according to the supported
versions of the operating systems: Microsoft Windows Server 2016 and 1709+.

Management Pack Recap – December 2018 Wave

This is a summary of the wave of Management Packs that were released in December 2018. Information and download location in the links provided:

Lenovo Hardware Management Pack v7.5.0.6here
File Services Management Pack for Windows Server 2016 and 1709+here
Windows Server DHCP 2012 Management Pack v6.0.7309.0  – here
Cluster Services MPhere
Skype for Business Server 2019here

If you know of any other Management Packs that have been released recently that I may have missed leave me a note in the comments and I’ll add them

SCOM: New File Services Management Pack for Windows Server 2016 and 1709+

A new management pack has been released for Windows Server 2016 and later File Services they are available for download the the following locations

Server 2016 and 1709+here

Server 2012here

Features

Includes new and updated monitoring for File Services, iSCI, DFS and DFS replication

File Services

  • DeDuplication – Stay current
  • FSRM
  • Support for clustered namespaces
  • Support for clustered replication group members
  • Agentless monitoring
  • More detailed product knowledge
  • Support for clustered replication group members
  • Agentless monitoring
  • iSCSI – iSCSI Target is built inbox first time in Server 2016. This is the first version integrated with File Server.
  • NFS – Stay current.
  • SMB – New

DFS Namespaces

Documentation updated to reflect Server 1709+

DFS Replication

New Support for Server 1709+

Management Pack Recap – October 2018 Wave

This is a summary of the wave of Management Packs that were released in October 2018. Information and download location in the links provided:

Active Directory Domain Services MP v10.0.2.2here
Azure Management Pack v1.6.0.0here

If you know of any other Management Packs that have been released recently that I may have missed leave me a note in the comments and I’ll add them