Tag Archives: sql

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

Creating Custom Service Manager Reports

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 , , , , , , , , | 26 Comments