Send netdisco-users mailing list submissions to
netdisco-users@lists.sourceforge.net
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
netdisco-users-requ...@lists.sourceforge.net
You can reach the person managing the list at
netdisco-users-ow...@lists.sourceforge.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Custom query help (Ricardo Stella)
2. Re: Custom query help (Juan Romero)
3. Re: Custom query help (Oliver Gorwits)
--- Begin Message ---
Hi folks, not a DBA nor programmer here so figure I ask if someone has done
something similar.
Trying to do a query or search for say "active access points running at
100mbps", or at least "devices running at less than 1gbps"
Any ideas on how to do this via the GUI or command line?
TIA
--
°(((=((===°°°(((================================================
--- End Message ---
--- Begin Message ---
Try sthg like this on the PSQL DB.
Replace:
like '%AV%'
with a wildcard matching your WAPs hostnames
-----------------------------------------------------
Juan J. Romero
Founder & Director
email: jrom...@auroranetworks.net
m: +61420246579
https://www.auroranetworks.net
https://logio.auroranetworks.net
Aurora Networks Managed Services
ABN: 50 627 553 619
20-24 Premier Street
Kogarah, NSW 2217
<https://www.auroranetworks.net/assets/img/demo/anms_full_logo.png>
Follow us on Locals:
https://cybersec.locals.com/
-----Original message-----
From: Ricardo Stella
Sent: Wednesday, August 25 2021, 7:52 am
To: netdisco-users@lists.sourceforge.net
Subject: [Netdisco] Custom query help
Hi folks, not a DBA nor programmer here so figure I ask if someone has done
something similar.
Trying to do a query or search for say "active access points running at
100mbps", or at least "devices running at less than 1gbps"
Any ideas on how to do this via the GUI or command line?
TIA
--
°(((=((===°°°(((================================================
_______________________________________________
Netdisco mailing list
netdisco-users@lists.sourceforge.net
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
--- Begin Message ---
Hi Ricardo and Juan
Yes Juan is right, that's the easiest method if you have consistently named
access points. You can start with the reports here:
https://github.com/netdisco/netdisco/wiki/Custom-Reports
(yes we started a wiki page for helping this)
The first report joins the device and device_port table which is what you
need to do to get both the hostname (device.dns) and speed
(device_port.speed).
Alternatively, to select devices which report themselves as APs, join on
device_port_properties and inspect the remote_is_wap field:
LEFT JOIN device_port_properties ON device_port.ip = device_port_properties.ip
...
WHERE remote_is_wap
Just think about which way round you are doing it: looking for APs with
ports running less than 1Gbps, or switch ports connected to APs running
less than 1Gbps.
It might be easier to do the second because APs have multiple interfaces
and you only want the uplink to the switch after all.
Good luck,
Oliver.
On Wed, 25 Aug 2021 at 04:51, Juan Romero <jrom...@auroranetworks.net>
wrote:
> Try sthg like this on the PSQL DB.
>
> Replace:
>
>
>
> like '%AV%'
>
>
>
> with a wildcard matching your WAPs hostnames
>
>
>
>
>
>
>
>
>
>
>
>
>
> -----------------------------------------------------
>
> Juan J. Romero
>
> Founder & Director
>
> email: *jrom...@auroranetworks.net <jrom...@auroranetworks.net>*
>
> m: *+61420246579*
>
> https://www.auroranetworks.net
>
> https://logio.auroranetworks.net
>
> Aurora Networks Managed Services
>
> ABN: 50 627 553 619
>
> 20-24 Premier Street
>
> Kogarah, NSW 2217
>
>
>
> Follow us on Locals:
>
> https://cybersec.locals.com/
>
> -----Original message-----
> *From:* Ricardo Stella
> *Sent:* Wednesday, August 25 2021, 7:52 am
> *To:* netdisco-users@lists.sourceforge.net
> *Subject:* [Netdisco] Custom query help
>
> Hi folks, not a DBA nor programmer here so figure I ask if someone has
> done something similar.
>
> Trying to do a query or search for say "active access points running at
> 100mbps", or at least "devices running at less than 1gbps"
>
> Any ideas on how to do this via the GUI or command line?
>
> TIA
>
> --
> °(((*=*((*===°°°*(((*================================================*
>
>
>
> _______________________________________________
>
> Netdisco mailing list
> netdisco-users@lists.sourceforge.net
> https://sourceforge.net/p/netdisco/mailman/netdisco-users/
>
> _______________________________________________
> Netdisco mailing list
> netdisco-users@lists.sourceforge.net
> https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users