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

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

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...