Collection exclusions

[johanneske]

Hi all

 

I hope that someone can help me with the following

 

I need to create a collection

I need to deploy a lot of software to computers but unfortunately not to all computers

I want to create a collection based on all computers starting with TI (first two characters of all our compuers) except the computers that are on this exception list ( i have an Active Directory group for these computers named All_Exclusion_COMP)

I hope someone has a solution for this

 

Thx

 

J

[Eswar Koneti]

Hi,

here is the collection query, try this out :

 

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 where Name like "TI%" and SystemGroupName != "ESKON\\APP_Adobe_Reader_9.1.3_ENG"

 

where ESKON -domain name

APP_Adobe_Reader_9.1.3_ENG -AD security group name

[johanneske]

Hi Konetie

 

Thx for you help

I tested the query but the exclusion list (based on my AD group) is stil in the collection

So the statement system group name is not equal to "My AD group" does not work

The computers listed in my exclusion group are still member of the collection

 

Do you have any other suggestions

 

Thx

 

J

[Eswar Koneti]

Hi Konetie

 

Thx for you help

I tested the query but the exclusion list (based on my AD group) is stil in the collection

So the statement system group name is not equal to "My AD group" does not work

The computers listed in my exclusion group are still member of the collection

 

Do you have any other suggestions

 

Thx

 

J

 

Hi,

Yes ,it will discover all the computers that starts with TI and excludes computers from exclustion group but still discovers the exclustion computers from other groups( even from AD) as well (becuase computers are not unique if you AD security groups). You can move the exclusion computers to Particual OU and exclude the OU to not discover the computers.