Akinkawon Posted November 7, 2013 Report post Posted November 7, 2013 Hey guys, I am fairly new to the world of SCCM Administration (4 months), but I have maintained fairly well. There is one aspect that I would like to get a better grasp on and that is creating custom queries. An example of a job that I have been tasked with is finding all versions of Java in the environment which devices they are installed on. Now with my experience I know that the results will be very robust, but informative as well. If someone has an example of a query that can assist me with reaching this goal it would be greatly appreciated. Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted November 8, 2013 Report post Posted November 8, 2013 Query or Reports. They are completely different. Query = Collections = WQL; Reports = SSRS = SQL This will help you will a report. http://smsug.ca/blogs/garth_jones/archive/2012/03/11/link-to-name.aspx Quote Share this post Link to post Share on other sites More sharing options...
Akinkawon Posted November 8, 2013 Report post Posted November 8, 2013 I would be more inclined to say that I'm looking for how to build better queries. I'm looking for more specific results when looking for things such as specific installs of certain software and things such as that. The list of reports is so robust, but there are some very good reports as well. If there is a more effective way to obtain this data I'm open. Quote Share this post Link to post Share on other sites More sharing options...
