Create sccm collection based on SCCM report

How do I create a SCCM collection based on a list of computers that I got from a report I ran in SCCM?

I am using SCCM 2007 SP1.

0 Comments   [ + ] Show comments

Answers (3)

Posted by: piyushnasa 9 years ago
Red Belt

Go to Queries section and create one Query.

You can also create a query in SQL the way you created for your report and point your collection to pick the query and populate itself. So basically use Query for collection. 

Posted by: bretthexum 9 years ago
Yellow Belt

Should be able to export that report to a csv, and then install and use right click tools to import into a new collection


  • Won't be a dynamic collection though. - Ifan 9 years ago
    • Ahhh yes, I didn't realize you needed that. Thought it was a one time thing. The answer below could also work. Convert the SQL to WQL - bretthexum 9 years ago
Posted by: Ifan 9 years ago
Second Degree Green Belt

The problem is that the reports queries are written in SQL while collection queries are written in WQL.
You'll have to rewrite the report query in WQL. What are the specifics of your wanted query?

  • I'm planning on deploying packages to these collections to uninstall old version of software that aren't needed. - ClaudiuP 9 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ