Create all servers collection except DC's and clusters and manually added servers

SCCM 2012 R2 SP1

Need help creating a collection

For patch management I need to create a collection with all servers except Domain controllers and clusters.

Also I need to be able to add servers names to be excluded. Those servers I patch manually.

Thanx

September 9th, 2015 11:43am

Well the easy thing would be to make a collection that contains all the servers. Use a query for this.

This is what i used:

select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from  SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Name like "%Server%" and SMS_R_System.Client = "1"

Create a collection that contains all the DC. Use a query for this it could be based on the AD OU or the name of your DC.

Create a collection that contains all the cluster. Use a query for this could be done via the name or location in AD in something else you know all your cluster have in common.

Now in the first collection add the collections above as exclusion (all dc and all cluster)

You could also make a collection with all the name server you want. This will be direct base and add this collection as a exclusion to the other one.

This is the easy solution.

The best solution would be for you to come with a query that add all the servers and also exclude the one you don't want. Also try to avoid direct membership because they don't live you need to always be aware of them and do the modification. In some case you can't avoid it but if you can do so.




Free Windows Admin Tool Kit Click here and download it now
September 9th, 2015 11:50am

Create a collection that contains all the DC. Use a query for this it could be based on the AD OU or the name of your DC.

Create a collection that contains all the cluster. Use a query for this could be done via the name or location in AD in something else you know all your cluster have in common.



I would use the role (SMS_G_System_COMPUTER_SYSTEM / Roles: like "%Domain_Controller%") for creating the DC collection.

Clusters can most likely be identified similar (don't have access to the console right now).

September 9th, 2015 12:47pm

If you have access to and influence over AD and your AD structure allows it, you could use OUs to organize things.  Then base your queries on the AD OUs/containers. . .

Just another option. . .the suggestions so far are great, though.

Jeff

Free Windows Admin Tool Kit Click here and download it now
September 9th, 2015 1:25pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics