Can anyone tell me how to create a Dynamic Query that lists all clients on a certain IP-Subnet? I can do it for a standard membership query in the collection, but you have to manually select the clients to be added, and therefore it will not update (dynamically) if new Clients are added to that Subnet. Cheers.

Using IP subnets for collections is generally a bad idea but here you go: 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_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceId = SMS_R_System.ResourceId where (SMS_R_System.IPAddresses like "10.4.112.%")John Marcum | http://myitforum.com/cs2/blogs/jmarcum |

try this http://tinyurl.com/24ltqmqhttp://www.enhansoft.com/