Tag Archives: query

CosmosDB Queries – Handling Arrays, Special Characters and Keywords

Posted on 07/07/2019 by Marcel Zehner

CosmosDB queries for arrays, special characters and keywords Continue reading →

Posted in Azure | Tagged , , , , , , , , , , , , | 2 Comments

OMS welcomes the new “Azure Analytics Query Language”

Posted on 02/08/2017 by Marcel Zehner

If you are a using OMS Log Analytics you know that the query language offers some powerful features to extract, aggregate, analyze and visualize collected data. However, there are times when some restrictions kick in and you have to find … Continue reading →

Posted in Azure | Tagged , , , , | 3 Comments

SQL Query for Custom Reports – concatenate values in 1:many relationships

Posted on 14/05/2013 by Marcel Zehner

As soon as it comes to custom reporting in Service Manager, you are sooner or later dealing with SQL queries to get the needed data out of the data warehouse and into your reports. One of my customers came up … Continue reading →

Posted in SCSM | Tagged , , , , , | 1 Comment