Kusto Query Language: the PowerShell of query languages?

I don’t usually get into speculation or predictions. More often than not they turn out wrong. However, something that I’ve been thinking about is the Kusto Query Language, which is the language behind many of my recent posts on Azure Log Analytics. But the PowerShell of query languages? PowerShell is pretty ubiquitous at this point, …

Read moreKusto Query Language: the PowerShell of query languages?

Format the TimeGenerated Field Azure Log Analytics

I was recently writing a summary performance report binned by day. If you have used the summarize operator with bin you know that the TimeGenerated field has a lot of extra characters on it. So naturally my next question was how do you format the TimeGenerated Field?  I took a look at the official format_datetime() …

Read moreFormat the TimeGenerated Field Azure Log Analytics

Timer Trigger Azure Functions: Post logs to Log Analytics

In my previous post I showed how to create HTTP trigger Powershell Azure Function. Timer triggers have a number of difference uses for Ops people. They can be used to schedule start Azure Automation Runbooks, run a query against a database in a set interval, or check the response time on a website. In this …

Read moreTimer Trigger Azure Functions: Post logs to Log Analytics

Powershell Azure Functions: Severless for Ops People

Perhaps you’ve heard of Azure Functions, or maybe more generally serverless computing or serverless apps. If you haven’t heard of it, here is a blurb from MS: Serverless computing is the abstraction of servers, infrastructure, and operating systems. When you build serverless apps you don’t need to provision and manage any servers, so you can …

Read morePowershell Azure Functions: Severless for Ops People

Microsoft Monitoring Agent Performance Data Issue, SCOM, Azure Log Analytics

I recently had a Microsoft Monitoring Agent Issue, where some of my servers stopped sending any data to Azure Log Analytics and Performance data was not getting input into SCOM. My time was 4 hours off on my Hyper-v server which meant all my guests times were off too. However, I still had data going …

Read moreMicrosoft Monitoring Agent Performance Data Issue, SCOM, Azure Log Analytics