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. Re: Custom query help (Ricardo Stella)
--- Begin Message ---
Problem is, I get the following errors with the second report. Line 126 in
deployment.yml is the second -tag line:
PS: Anyone willing to help with the report I'm trying to do?
Unable to parse the configuration file:
/home/netdisco/environments/deployment.yml: YAML::XS::Load Error: The
problem:
did not find expected key
was found at document: 1, line: 126, column: 2
while parsing a block mapping at line: 13, column: 1
at /home/netdisco/perl5/lib/perl5/Dancer/Config.pm line 232.
Dancer::Config::load_settings_from_yaml('/home/netdisco/environments/deployment.yml',
'YAML') called at /home/netdisco/perl5/lib/perl5/Dancer/Config.pm line 205
Dancer::Config::load('Dancer::Config') called at
/home/netdisco/perl5/lib/perl5/Dancer.pm line 274
Dancer::import('Dancer', ':script') called at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/DNS.pm line 5
App::Netdisco::Util::DNS::BEGIN() called at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/DNS.pm line 5
eval {...} called at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/DNS.pm line 5
require App/Netdisco/Util/DNS.pm called at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/DeviceAuth.pm line 4
App::Netdisco::Util::DeviceAuth::BEGIN() called at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/DNS.pm line 5
eval {...} called at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/DNS.pm line 5
require App/Netdisco/Util/DeviceAuth.pm called at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Configuration.pm line 4
App::Netdisco::Configuration::BEGIN() called at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/DNS.pm line 5
eval {...} called at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/DNS.pm line 5
require App/Netdisco/Configuration.pm called at
/home/netdisco/perl5/lib/perl5/App/Netdisco.pm line 8
App::Netdisco::BEGIN() called at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/DNS.pm line 5
eval {...} called at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/DNS.pm line 5
require App/Netdisco.pm called at
/home/netdisco/perl5/bin/netdisco-backend-fg line 20
main::BEGIN() called at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/DNS.pm line 5
eval {...} called at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/DNS.pm line 5
BEGIN failed--compilation aborted at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/DNS.pm line 5.
Compilation failed in require at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/DeviceAuth.pm line 4.
BEGIN failed--compilation aborted at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/DeviceAuth.pm line 4.
Compilation failed in require at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Configuration.pm line 4.
BEGIN failed--compilation aborted at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Configuration.pm line 4.
Compilation failed in require at
/home/netdisco/perl5/lib/perl5/App/Netdisco.pm line 8.
BEGIN failed--compilation aborted at
/home/netdisco/perl5/lib/perl5/App/Netdisco.pm line 8.
Compilation failed in require at
/home/netdisco/perl5/bin/netdisco-backend-fg line 20.
BEGIN failed--compilation aborted at
/home/netdisco/perl5/bin/netdisco-backend-fg line 20.
On Thu, Aug 26, 2021 at 6:05 PM Jethro Binks <jethro.bi...@strath.ac.uk>
wrote:
> There should only be one
>
> reports:
>
> keyword followed by a tag: for each report. Your second reports: tag is
> overriding the first, just remove it.
>
> Jethro.
>
> . . . . . . . . . . . . . . . . . . . . . . . . .
>
> Jethro R Binks, Network Manager,
>
> Information Services Directorate, University Of Strathclyde, Glasgow, UK
>
>
> The University of Strathclyde is a charitable body, registered in Scotland,
> number SC015263.
>
> ------------------------------
> *From:* Ricardo Stella <ste...@rider.edu>
> *Sent:* 25 August 2021 20:52
> *To:* Oliver Gorwits <oli...@cpan.org>
> *Cc:* netdisco-users@lists.sourceforge.net <
> netdisco-users@lists.sourceforge.net>
> *Subject:* Re: [Netdisco] Custom query help
>
>
> Thanks - Two questions:
>
> * How can you do multiple reports? It only looks like the last one defined
> is shown. I have them as follows:
>
> reports:
> - tag: wap_speed
> ...
> reports:
> - tag: admin_up_down
> ...
>
> * Also, looks like I'm not sure how to do this one - Syntax seems correct,
> but getting search failed.
>
> reports:
> - tag: wap_port_speeds
> label: 'WAP Port Speeds'
> columns:
> - { host: Device_name}
> - { ip: ip}
> - { port: Port}
> - { name: Description}
> - { speed: 'Speed'}
> query: |
> SELECT device.name AS host, device_port.ip, device_port.port,
> device_port.name
> FROM device_port
> LEFT JOIN device_port_properties ON device_port.ip =
> device_port_properties.ip
> WHERE remote_is_wap
>
> Ricardo.
>
> On Wed, Aug 25, 2021 at 3:42 AM Oliver Gorwits <oli...@cpan.org> wrote:
>
> 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/
>
>
>
> --
> °(((=((===°°°(((================================================
> _______________________________________________
> 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
