Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

dymanic query to list all 192.168.x systems

Created: 19 Jul 2013 | 3 comments

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.

Operating Systems:

Comments 3 CommentsJump to latest comment

md investigate's picture

Hi,

Have a look on following thread for filter query: https://www-secure.symantec.com/connect/forums/fil...

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

MichaelCiv's picture

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

prince_y's picture

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