Jump to content




Sign in to follow this  
peled

Collection base on IP & AD Group membership



Recommended Posts

I want to build a collection that will inclode all Computer that sub net is 10.10.10.x & 10.10.11.x, that are NOT members in Group1 from AD.

Thanks

Peled

Share this post


Link to post
Share on other sites


I want to build a collection that will inclode all Computer that sub net is 10.10.10.x & 10.10.11.x, that are NOT members in Group1 from AD.

Thanks

Peled

 

You can try this collection:

 

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_NETWORK_ADAPTER_CONFIGURATION on

SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId

inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId

where (SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like "192.168.1.%" or

SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like "192.168.2.%") and

SMS_G_System_SYSTEM.ResourceID not in (select SMS_R_SYSTEM.ResourceID from

SMS_R_System where SMS_R_System.SystemGroupName = "eskonr\\Adobe_Acrobat")

 

Replace the Bold Letters with you information

Share this post


Link to post
Share on other sites

Similar to the request above, is it possible to create a collection based on a user belonging to a group but not logged into a computer on a subnet.

So if UserA is on subnetX they are in the collection. But if UserA is on subnetY they aren't in the collection.

 

Is this even practical?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


×