/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Create sccm collection based on SCCM report

05/13/2013 12069 views

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



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

All 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
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.

Don't be a Stranger!

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

Sign up! or login

Share

 
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