SOLVED custom reporting for SCCM

[Michael Britt]

Looking for some help with creating custom reports in SCCM not a DBA so I feel like a fish out of water. What I am trying to do is get a report that shows device by model, name, RAM, CPU and, OS. Any help would be great. Thanks.

 

[Garth]

First look at the builtin reports, there is one that should help, particularly in the AI category.

 

[Michael Britt]

I will take a look thanks.

 

[Edy]

Hi Michael,

First you need to google up how to build a custom report and secondly the WQL query for the report.

I still prefer to use SQL because I can easily query a table and find the field that i am looking for.

You can do the same by saving the SQL query and reuse it.

Start small and gradually you will learn more advanced query.

A quick google search leads me to this website with collection of SQL queries Link

 

[Garth]

Hi Michael,

First you need to google up how to build a custom report and secondly the WQL query for the report.

I still prefer to use SQL because I can easily query a table and find the field that i am looking for.

You can do the same by saving the SQL query and reuse it.

Start small and gradually you will learn more advanced query.

A quick google search leads me to this website with collection of SQL queries Link

wouldn't the first thing to do is look at the builtin report and reuse them before reinventing the wheel.

as for googling i agree it is a good thing but make sure that you understand the source and author. there are lots of bad/unsupported examples out there.

if you want to report reporting then check out one of the books on the subject.

 

[Edy]

not for me. many times, its much easier and quicker to do a SQL query to just extract what i need instead of going to builtin reports and modify the report to add/remove fields.

 

[Garth]

are you writting a report or just running a sql query? i agree that if you know what you doing writting a one off query can be fair fast but it is not repeatable. as such, when it will be use time and time again, running a report will be faster. plus the report will allow other to run the report anytime thereby freeing up your time.

 

[Michael Britt]

Sorry to take so long to get back to this. I did find a built in report that took care of my needs. to the point of writing a SQL query that has never been something I have done since I have no real knowledge of how SQL works. I don't want to blow up a database.

 

[Edy]

Sorry to take so long to get back to this. I did find a built in report that took care of my needs. to the point of writing a SQL query that has never been something I have done since I have no real knowledge of how SQL works. I don't want to blow up a database.

This is a general presumption that when you directly connected to the database that you can do a lot of damage. The statement is true however you can also connect with read-access and only use "SELECT" statement.