Send netdisco-users mailing list submissions to
[email protected]
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
[email protected]
You can reach the person managing the list at
[email protected]
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 (Juan Romero)
--- Begin Message ---
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: [email protected]
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: Saturday, August 28 2021, 6:45 am
To: Jethro Binks
Cc: [email protected]
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 <[email protected]>
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 <[email protected]>
Sent: 25 August 2021 20:52
To: Oliver Gorwits <[email protected]>
Cc: [email protected] <[email protected]>
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 <[email protected]> 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 <[email protected]> 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: [email protected]
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: [email protected]
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
[email protected]
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
_______________________________________________
Netdisco mailing list
[email protected]
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--
°(((=((===°°°(((================================================
_______________________________________________
Netdisco mailing list
[email protected]
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--
°(((=((===°°°(((================================================
_______________________________________________
Netdisco mailing list
[email protected]
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
