Category Archives: Reporting

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

Posted on 14/05/2013 by

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 Reporting | Tagged , , , , , | Leave a comment

The Case of the lost Report Data Sources

Posted on 03/11/2012 by

Maybe you had this one before: after doing a fresh install of Service Manager or even after SCSM Reporting was already up and running, some or all of the reports lost the connection to their data source. Because I had … Continue reading →

Posted in Reporting, Troubleshooting | Tagged , , , , , | Leave a comment

Creating Custom Service Manager Reports with Parameters

Posted on 03/09/2012 by

A while ago I published an article on how to create custom Service Manager reports –> see here. This post is a follow up article that explains how to use report parameters to filter the displayed results. This can be … Continue reading →

Posted in Reporting | Tagged , , , , | 3 Comments

Creating Custom Service Manager Reports

Posted on 14/08/2012 by

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 Reporting | Tagged , , , , , , , , | 9 Comments

Data Cubes in Service Manager 2012 – Part 3/3 (Creating your own Data Cubes)

Posted on 12/08/2012 by

Finally … this is the third part of a series that explains data cubes in Service Manager 2012. The first and the second part have been published in January and February 2012. Sorry for the delay of this last part. … Continue reading →

Posted in Reporting | Tagged , , , , , | 8 Comments

Service Manager Management Group Documentation

Posted on 30/06/2012 by

Wow, that was a long time without blogging. The reason why is that I have tons of System Center projects to work on and my time is somehow vanishing. But now be prepared for a series of new posts on … Continue reading →

Posted in Classes and Relations, General, Reporting | Tagged , , , , | 3 Comments

Data Cubes in Service Manager 2012 – Part 2/3 (Publishing Reports)

Posted on 06/02/2012 by

In the first blog post of this series I described the basic handling of data cubes, how to create them and how to slice and dice data by using excel. Now let’s go to the next step with Data Cubes in … Continue reading →

Posted in Reporting | Tagged , , , , , , | 14 Comments

Data Cubes in Service Manager 2012 – Part 1/3 (Overview and basic handling of Data Cubes)

Posted on 02/01/2012 by

One cool new thing in SM12 is the ability to calculate data cubes that allow analysts to slice and dice data to get relevant information out of the data warehouse. This is a good alternative to regular Reporting which can sometimes … Continue reading →

Posted in Reporting | Tagged , , , | 20 Comments

Formatting Problem when Reports are exported

Posted on 10/03/2011 by

Service Manager can be used to create Reports, either by creating them directly in the console or by using a schedule to automatically create reports based on a defined interval (see this blog post for more details). There are times when … Continue reading →

Posted in Reporting | Tagged , , , | Leave a comment

Scheduled Reports

Posted on 09/03/2011 by

One question that comes up frequently is how Service Manager reports can be scheduled. The good news: This can be done, hooray! The bad news: It cannot be done using the Service Manager console and it can be a bit … Continue reading →

Posted in Notification, Reporting | Tagged , , , , | 1 Comment