Client Management Suite

Hi,

I looked at some of my old queries and some are more elaborate (thanks to Altirigos and Symantec Guys) here, but I am looking for a dymanic query to list all 192.168.x systems for a filter. Not sure it will accomplish the end goal because even I can use on the query would be drawing on data from Basic Inventory, right? I would need to know the IP address right at that specific moment this policy is being included as part of a SMS policy.

 

Hi, Have a look on following thread for filter query: https://www-secure.symantec.com/connect/forums/filters-or-groups-based-ip-range You are right, the data is based on Basic inventory. When you need "real time" data you can have an applicability rule in the Software. Regards

If you're just looking for a query then its actually pretty simple...you could use this to generate your filter

select * from vComputer where [IP Address] like '%192.168.%'

select * from Inv_Aex_AC_TCPIP where [subnet]='192.168.0.0'