techguy.at
System Center Service Manager–SQL Query to get a full List of your Incidents » TechGuy
In the most cases, the Reporting has to be done through the Data warehouse DB for SCSM, but in some cases you have to get all the Data from the ServiceManager DB. For Example if you don't have a Data warehouse DB for SCSM or you need some more Details.