In part 1 we got a pretty good understanding how joins work and what the results are. To make this a complete series we will now work on the remaining join types. Full Outer The fullouter join is a join that shows in addition to the inner matches, there’s a row for every row on […]
Azure
Azure Log Analytics – Testing JOINs Part 1
Azure Log Analytics offers you a powerful language to analyze your data. I am not a SQL query specialist but as far I can tell there are many similarities between SQL language and (New) Azure Log Analytics query language. One cool thing we can do is using joins. If you look up what a join […]
Azure Dashboard – Execute Azure Log Analytics Queries
Building good, meaningful dashboards for monitored components is one of the hardest disciplines in a monitoring guys life – at least in my opinion. One little known hero in the Azure dashboard world is the “Markdown” tile… It has the power of running HTML fragments inside as you can see in the sample text provided… […]
Azure Monitor – New Alerts Experience (Preview)
I have been following the updates from Azure Monitor since its birth. Because I am also interested in OMS / Azure Log Analytics it has been an exciting time to see in what direction both products are moving. As we can clearly see the parts of OMS are moving into the Azure portal, there is […]
Azure Log Analytics – Portal Refresh
It has been not long ago when Microsoft introduced the new Azure Log Analytics query language and also the new portal experience at http://portal.loganalytics.io . Just as we got used to the portal, I noticed some refreshes and clean up. The portal looks now like this… …the menu to run the query, set the interval, […]
OMS – Monitor Windows Services / Processes
One thing I am missing in OMS is, to monitor windows services and processes easily. Well, there are many ways to monitor such components with OMS like: Run some sort of PowerShell script on the server to check the windows service or processes status and then use the HTTP Data Collector API to ingest the […]
Azure Log Analytics – Cross Workspace Query Resolve Workspace ID
At Ignite 2017 Microsoft introduced a new functionality in Azure Log Analytics (ALA) to write queries across workspaces. This has been a long awaited feature for many customers. Why? Let’s imagine you want to provide IT services for customers and you would like to keep data separated for each customer in its own workspace. At […]
Azure Application Insights – Using Squared Up Web API
Many of you know Squared Up for their powerful HTML 5 dashboard solution for SCOM. It does an awesome job displaying data in a fast and easy way. There is also a way to display OMS data within the dashboard using the OMS tile. Although this is very cool as you are able to combine […]
Azure Logic App – Send Data From Application Insights To Azure Log Analytics
If you followed the Ignite 2017 announcements and Microsoft’s latest trends you figured out that serverless applications are getting more and more boost in Microsoft’s cloud strategy. Logic Apps is one of these new awesome iPaaS (integration Platform as a Service) services, which let’s you reduce complexity, coding and also headache :). Microsoft summarizes the […]
OMS – Upgrade Workspace Error
Few weeks ago Microsoft introduced the new Azure Log Analytics query language to OMS Log Analytics. In order to use the new language with your workspace you need to upgrade your current workspace. It is very simple and basically a one-click experience and there are new features available as MVP Marcel Zehner describes in his […]