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 […]
OMS
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… […]
OMS – OMS Gateway Chaining
I had an interesting question few weeks ago, which I could not answer for sure. I was asked, if it is possible to chain OMS gateways. I would have said yes in the first place, because they are just proxies. But so far I haven’t tested it. So, I decided to build this scenario in […]
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 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 […]
Azure Automation – Up / Down Scale Azure VM
Recently I made a couple of demos how you could benefit from Azure Automation acting on certain alerts. One demo was, if an OMS or Azure Monitor alert is triggered because of high CPU on your Azure VM, a webhook will be called and scale up the Azure VM to a predefined size. In Azure […]
ARM Template – Deployment Error “[Subscription().SubscriptionId]” The request is invalid…
Recently I authored some ARM stuff in Visual Studio and I had a need for getting the current subscription ID the template is being deployed to. So there is a helper function you can call like this… “subscriptionId”: “[subscription().subscriptionId]” I used it in the template like this… …but as soon I tried to deploy the […]