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

Comments

Please log in to comment

Community Chosen Answer

1

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. 

Answered 05/21/2013 by: piyushnasa
Red Belt

Please log in to comment

Answers

0

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

http://myitforum.com/cs2/blogs/rhouchins/archive/2008/04/09/sccm-right-click-tools.aspx

Answered 05/13/2013 by: bretthexum
Yellow Belt

  • Won't be a dynamic collection though.
    • 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
Please log in to comment
0

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?

Answered 05/14/2013 by: Ifan
Second Degree Green Belt

  • I'm planning on deploying packages to these collections to uninstall old version of software that aren't needed.
Please log in to comment
Answer this question or Comment on this question for clarity

Share