I'm having trouble using SMS to target package distribution to my client machines. It is easy for me to create custom dynamic collections but using them to target my machines is becoming a problem.
I think my problem is related to filtering a collection.
For example, say I want to run a package (that reboots the machine) on all systems using Internet Explorer 5.5 with SP2. But I also need to avoid running this package on 80 SMS client machines because they are high visibility IIS servers and other important application servers.
1) I can create a SQL query to contain all SMS clients running IE 5.5 w/SP2. I can even create an SMS collection based on this SQL query.
2) I can also create a collection using MAKECOLL.exe to create a collection of the 80 servers that I can not deploy the SMS package to...do to management declaring these servers high visibility and important application servers, etc so I must skip these (filter these systems out.)
However, I don't know if there is a way to Build a Collection based on the SQL query but also subtracting the 80 servers Collection. (i.e. SQL Query with filter based on another Collection.)
My goal is to create dynamic queries in SMS (because systems are added and subtracted all the time) and the filter these queries or collection on a Direct Membership static list of high availability servers.
Is there any way to do this? Or am I approaching this the wrong way? Any help would be greatly appreciated.
Thank you,
Joseph L. Poandl
MCSE 2000
If your company is in need of experts to examine technical problems/solutions, please check out (Sales@njcomputernetworks.com)
I think my problem is related to filtering a collection.
For example, say I want to run a package (that reboots the machine) on all systems using Internet Explorer 5.5 with SP2. But I also need to avoid running this package on 80 SMS client machines because they are high visibility IIS servers and other important application servers.
1) I can create a SQL query to contain all SMS clients running IE 5.5 w/SP2. I can even create an SMS collection based on this SQL query.
2) I can also create a collection using MAKECOLL.exe to create a collection of the 80 servers that I can not deploy the SMS package to...do to management declaring these servers high visibility and important application servers, etc so I must skip these (filter these systems out.)
However, I don't know if there is a way to Build a Collection based on the SQL query but also subtracting the 80 servers Collection. (i.e. SQL Query with filter based on another Collection.)
My goal is to create dynamic queries in SMS (because systems are added and subtracted all the time) and the filter these queries or collection on a Direct Membership static list of high availability servers.
Is there any way to do this? Or am I approaching this the wrong way? Any help would be greatly appreciated.
Thank you,
Joseph L. Poandl
MCSE 2000
If your company is in need of experts to examine technical problems/solutions, please check out (Sales@njcomputernetworks.com)