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 ---
Each of those reports in the wiki work fine by themselves, but both one
after another don't
On Fri, Aug 27, 2021 at 5:09 PM Juan Romero <jrom...@auroranetworks.net>
wrote:
> Haven't done custom reports myself but that looks like a YAML parsing
> error, file syntax.
>
>
>
> Check spaces/tabs in the reports section of your file. In the wiki page (
> https://github.com/netdisco/netdisco/wiki/Custom-Reports) I see some
> examples in the way the queries are formatted
>
>
>
> -----------------------------------------------------
>
> 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:* Saturday, August 28 2021, 6:45 am
> *To:* Jethro Binks
> *Cc:* netdisco-users@lists.sourceforge.net
> *Subject:* Re: [Netdisco] Custom query help
>
>
> 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/
>
>
>
> --
> °(((*=*((*===°°°*(((*================================================*
>
>
>
> _______________________________________________
>
> 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
