How difficult is it to write SQL reports in SCCM?

N2IT

I have fairly strong SQL knowledge and was wondering how complex is it to write reports in SCCM using the SQL editor

I've done a few but most were very simple with instructions lol

Any information would be greatly appreciated!

I believe this goes through SQL server report services, but when I ran them it was in SCCM, not SQL 2008 report services.

**Confused**

tenrou

If you want to create a new report then you can use t-SQL to generate the report but the 'SQL' that is used in filtering for app deployment and client collecitons isn't actually t-SQL it is WQL which is close but not close enough as your statements wont work. The syntax is almost identical but the table names etc are all different so it takes a bit of fiddling.

If you know your t-SQL then you will get used to it within a day or two, although I still find myself dropping to Management Studio a lot to establish what I need before passing the info into SCCM so that people needing reports just need to double click the report.