Apexes Posted April 1, 2015 Report post Posted April 1, 2015 Hi folks, My SQL knowledge is pretty bad, and i need to work on it What i'm trying to find is a statement i can run in SQL Management Studio that returns all computers that are in a specific collection ID. Can anyone help me at all? If so, i'd also like to know what the statement would be to add a machine name into said collection. Thanks in advance Jack Quote Share this post Link to post Share on other sites More sharing options...
Peter van der Woude Posted April 1, 2015 Report post Posted April 1, 2015 Erhm.. you want to use a SQL query to add a machine to a collection? You should do that through the console, or WMI. Never directly on the database. Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted April 1, 2015 Report post Posted April 1, 2015 Let me put it another way. It is complete not supported to do that. Quote Share this post Link to post Share on other sites More sharing options...
Garrett804 Posted April 6, 2015 Report post Posted April 6, 2015 Yup, add it in the console not in SQL itself. Quote Share this post Link to post Share on other sites More sharing options...
