Page 1 of 1

Fultering out Null SSID's

Posted: Sun Jun 28, 2009 5:49 pm
by mysticvirgo67
So now my DB's are flooded with AP's not broadcasting ssid's. I am not interested in those... They are mostly just the wifi connecting the traffic signals in my area and are, for all intents , just NOISE to me. What string do I use in the filter to exclude null ssid's?

Re: Fultering out Null SSID's

Posted: Sun Jun 28, 2009 10:00 pm
by ACalcutt
Good point....i never really considered that blank SSIDs couldn't be filtered out (I was just glad i finally got filtering working...haha). I will see what I can do to filter blank SSIDs.

Re: Fultering out Null SSID's

Posted: Tue Jun 30, 2009 10:41 am
by mysticvirgo67
well. I will try " " (blank in quotes) and see... As soon as I can entice the wife off of the laptop (new sims3 addict) :lol:

Re: Fultering out Null SSID's

Posted: Tue Jun 30, 2009 11:23 am
by ACalcutt
well even if that worked (which i don't think it will) that would only make you see blank access points. I'm thinking i need to add a not equal symobol "<>" to be able to filter out APs.


I was thinking about it and the only way to actually do this right now would be to modify the settings file before loading vistumbler.

Look for "AddQuery" and "RemoveQuery" under [Filters] in Settings\vistumbler_settings.ini. These could be modified to do what you want by doing this.

AddQuery=SELECT ApID, SSID, BSSID, NETTYPE, RADTYPE, CHAN, AUTH, ENCR, SecType, BTX, OTX, MANU, LABEL, HighGpsHistID, FirstHistID, LastHistID, LastGpsID, Active FROM AP WHERE SSID<>''
RemoveQuery=SELECT ApID, SSID, BSSID, NETTYPE, RADTYPE, CHAN, AUTH, ENCR, SecType, BTX, OTX, MANU, LABEL, HighGpsHistID, FirstHistID, LastHistID, LastGpsID, Active FROM AP SSID=''

Unfortunately if you do this you can't go into the settings GUI or it will redo those two sql queries from the filters that you have set.

Re: Fultering out Null SSID's

Posted: Tue Jun 30, 2009 11:31 am
by ACalcutt
well even if that worked (which i don't think it will) that would only make you see blank access points. I'm thinking i need to add a not equal symobol "<>" to be able to filter out APs.


I was thinking about it and the only way to actually do this right now would be to modify the settings file before loading vistumbler.

Look for "AddQuery" and "RemoveQuery" under [Filters] in Settings\vistumbler_settings.ini. These could be modified to do what you want by doing this.

AddQuery=SELECT ApID, SSID, BSSID, NETTYPE, RADTYPE, CHAN, AUTH, ENCR, SecType, BTX, OTX, MANU, LABEL, HighGpsHistID, FirstHistID, LastHistID, LastGpsID, Active FROM AP WHERE SSID<>''
RemoveQuery=SELECT ApID, SSID, BSSID, NETTYPE, RADTYPE, CHAN, AUTH, ENCR, SecType, BTX, OTX, MANU, LABEL, HighGpsHistID, FirstHistID, LastHistID, LastGpsID, Active FROM AP SSID=''

Unfortunately if you do this you can't go into the settings GUI or it will redo those two sql queries from the filters that you have set.

Re: Fultering out Null SSID's

Posted: Wed Jul 01, 2009 1:19 am
by mysticvirgo67
I'll try this , Andrew... Let you know in next couple days.. Laptop is our only machine currently able to run Sims3 so wife has siezed it to feed her addiction LOL

Re: Fultering out Null SSID's

Posted: Wed Jul 01, 2009 2:20 pm
by ACalcutt
You should be able to use a blank SSID and <> now (v9.6 Beta 7)

to not show blank SSIDs you can just use one of the following
<>
<>''
<>""
to show only blanks
<--nothing
''
""

quotes are ignored right now and arn't really needed (but can be used)

you can still seperate multiple entrys with a comma
<>,<>linksys,<>netgear

Re: Fultering out Null SSID's

Posted: Wed Jul 01, 2009 3:11 pm
by mysticvirgo67
kewlness! KAYTHXBai!