musc@> $daniele.work.ToString()

"Corporate" Blog of Daniele Muscetta, Premier Field Engineer.

So long and thanks for all the fish

This will be my last post on this blog. I have resigned from Microsoft.  The past twelve years have been quite a ride, first in the support organization, and then in engineering – working on OpsMgr first, then the prototype of what later became Application Insights, and in the last couple of years in the… Read more

Using Wire Data in Operations Management Suite Log Search

A little while ago we enabled in the OMS Portal the first iteration of a ‘Wire Data’ solution – check it out in the Solutions Gallery if you haven’t. We didn’t make it in time to formally announce it on the ‘momteam’ blog, but Stas has given us coverage anyways. So here’s a slightly more… Read more

Operations Management Suite Log Search How To: Part IX – the DISTINCT command

A nifty little addition to our language has been recently pushed out: the DISTINCT command. Now, before I continue, if you have just stumbled here but have no previous experience with the search syntax, notice that this is the ninth installment of a Series that walks thru the concepts of Operations Management Suite (formerly Microsoft… Read more

Operations Management Suite Log Search How To: Part VIII – the IN operator and subsearches

This is the eight installment of a Series that walks thru the concepts of Operations Management Suite (formerly Microsoft Azure Operational Insights) Search Syntax – while the full documentation and syntax reference is here, these posts are meant to guide your first steps with practical examples. I’ll start very simple, and build upon each example,… Read more

Which machines are reporting to Azure Operational Insights? Where is my data coming from? What data and how much is it?

I am sure you have seen our troubleshooting blog post that helps resolve Operational Insights connectivity and data flow issues. This post aims at showing you how you can use Operational Insights Search to see which machines/environments are sending data, get an understanding of what data (and how much of it) is being received by… Read more

Monitoring SQL Backup Failures with Azure Operational Insights Search and Dashboards

Besides the SQL Server Assessment Intelligence Pack, you can also use Log Management functionality to collect the ‘Application’ event log from your SQL Servers and monitor activity from it with search. For example, this is my simple recipe for finding SQL Backup Failures Type=Event EventID=3041 EventLog=Application Source=MSSQLSERVER That’s it. I can see in my workspace… Read more

Azure Operational Insights Search How To: Part VII – Measure Sum() and Where command

This is the seventh installment of a Series that walks thru the concepts of Microsoft Azure Operational Insights Search Syntax – while the full documentation and syntax reference is here, these posts are meant to guide your first steps with practical examples. I’ll start very simple, and build upon each example, so you can get… Read more

IIS MP Event-Alerting Rules’s OpInsights Searches Equivalents

Just for the kicks, the other day I run an Excel export of the IIS8 MP with MPViewer, and then I applied a bunch of filters and removed several columns and copied out to notepad all the key info for the Alerting Rules that are based on Windows Events. And then I added field names… Read more

Azure Operational Insights Search How To: Part VI – Measure Avg(), and an exploration of Type=PerfHourly

This is the sixth installment of a Series that walks thru the concepts of Microsoft Azure Operational Insights Search Syntax – while the full documentation and syntax reference is here, these posts are meant to guide your first steps with practical examples. I’ll start very simple, and build upon each example, so you can get… Read more

Azure Operational Insights Search HowTo: Part V – Max() and Min() Statistical functions with Measure command

This is the fifth installment of a Series (I don’t know yet how many posts they will be in the end, but I had at least 5 in mind at this point… and as I am writing I realize I won’t be done with this one…) that walks thru the concepts of Microsoft Azure Operational… Read more