The Curious Capabilities of Case Scalar Function

Have you checked out the Case scalar function? If not this post is all about what the capabilities of Case scalar function are. However, as I mentioned previously, there is a lot of good documentation around Kusto, and then there are others that could use more documentation, this is one of those examples. From the …

Read more

Azure Automation Update Management Workbook

Are you using Azure Automation Update Management? If not why not? It’s free for your Azure VMs. You can also use the Log Analytics portion by itself to track Update status. That said, the default dashboards are just OK, but are impossible to use with multiple subscriptions. Especially if you have multiple Log Analytics workspaces …

Read more

PowerShell: Enable Hyper-V De-Duplication

Enabling data de-duplication can have a sizeable impact on your used storage space. But did you also know that enabling de-duplication is currently a recommended best practice for general purpose Hyper-V hosts? Follow along and I’ll show you how to enable Hyper-V de-duplication using only PowerShell. If you are unfamiliar with installing Windows Features with …

Read more

Proud to Announce Sponsorship by SquaredUp

In the interest of full disclosure and respect for anyone that happens upon my site I have always made clear in posts if content was sponsored in anyway. That has not been the case, until now. As you can see in the top right corner there is a single ad for SquaredUp. Previous readers of …

Read more

Working with Time in Log Analytics

Inside Log Analytics and therefore many other products that use Kusto, we have many options to play with time.  In this post I’ll show real world examples when working with time in Log Analytics. In particular how to use Timespans, Datetime and Time Difference in Kusto. For the purposes of this post all examples will …

Read more

Log Analytics WVD Query Examples

Last year I did a project building monitoring in Log Analytics for Windows Virtual Desktop (WVD). I am providing these Log Analytics WVD Query Examples as is to help anyone that may be wanting to monitor WVD with Log Analytics. You can find the full github repo here These are some example queries based on …

Read more