musc@> $daniele.work.ToString()

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

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

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

Azure Operational Insights Search How To: Part IV – Introducing the MEASURE command

This is the fourth installment of a Series (I don’t know yet how many posts they will be in the end, but I have at least 5 in mind at this point…) that walks thru the concepts of Microsoft Azure Operational Insights Search Syntax – while the full documentation and syntax reference is here, these… Read more

Azure Operational Insights Search How To: Part III – Manipulating Results: the pipeline “|” and Search Commands

[Edited October 27th 2014 – System Center Advisor is now a part of the new Microsoft Azure Operational Insights – Click to learn more] This is the third installment of a Series (I don’t know yet how many posts they will be in the end, but I have at least 5 in mind at this… Read more

Azure Operational Insights Search How To: Part II – More on Filtering, using Boolean Operators, the Time Dimension, Numbers and Ranges

[Edited October 27th 2014 – System Center Advisor is now a part of the new Microsoft Azure Operational Insights – Click to learn more] This is the second installment of a Series (I don’t know yet how many posts they will be in the end) that walks thru the concepts of Microsoft Azure Operational Insights… Read more