Skip to content

Collection exclusions

Featured Replies

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

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

  • Author

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.