Tag Archives: query

CosmosDB Queries – Handling Arrays, Special Characters and Keywords

CosmosDB queries for arrays, special characters and keywords Continue reading

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

OMS welcomes the new “Azure Analytics Query Language”

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

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