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)
Please log in to answer
Posted by:
piyushnasa
10 years ago
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
10 years ago
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
Comments:
-
Won't be a dynamic collection though. - Ifan 10 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 10 years ago
Posted by:
Ifan
10 years ago
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?
Comments:
-
I'm planning on deploying packages to these collections to uninstall old version of software that aren't needed. - ClaudiuP 10 years ago
