Tag Archives: sql

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

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

Creating Custom Service Manager Reports

Posted on 14/08/2012 by Marcel Zehner

When you are working with Service Manager, you have some report definitions that are delivered with Management Packs for basic reporting. With SM12, the concept of OLAP Cubes is another method that you can use for getting information out of … Continue reading →

Posted in SCSM | Tagged , , , , , , , , | 28 Comments