Video Screencast Help

dymanic query to list all 192.168.x systems

Created: 19 Jul 2013 | 3 comments


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.

Operating Systems:

Comments 3 CommentsJump to latest comment

md investigate's picture


Have a look on following thread for filter query:

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.


MichaelCiv's picture

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

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

prince_y's picture

select * from Inv_Aex_AC_TCPIP
where [subnet]=''