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. Addon report - what devices subnets are configured (Muris)
2. Re: Addon report - what devices subnets are configured
(Jethro Binks)
--- Begin Message ---
Hi all,
I made an addon report for showing what subnets are configured on which devices
with their descriptions and vlan ids. This only works well considering the
devices pull all the information in the “Addresses” tab in netdisco user
interface. I had some issues with Nexus MPLS devices, where the vlans don’t
fully show under the “Addresses” tab so if netdisco doesn’t see the subnets it
won’t capture everything (hoping that will be fixed one day)
If you would like to trial it -
Modify the deployment.yml file, find “reports:” on bottom then add it underneath
- tag: SubnetsConfiguredOnDevices
category: IP
label: 'Subnets Configured on Devices'
columns:
- {Subnet: 'Subnet'}
- {Description: 'Description'}
- {VLANID: 'VLAN ID'}
- {DeviceNameConfigured: 'Device Name Configured'}
query: |
SELECT DISTINCT
CAST(s.net AS TEXT) AS Subnet,
dp.name AS Description,
COALESCE(dp.vlan, di.port) AS VLANID,
d.name AS DeviceNameConfigured
FROM
subnets s
JOIN
device_ip di ON s.net = di.subnet
JOIN
device d ON di.ip = d.ip
JOIN
device_port dp ON di.ip = dp.ip AND dp.port LIKE '%lan%' AND dp.port =
di.port
WHERE
s.net IS NOT NULL
ORDER BY
Subnet, Description, VLANID, DeviceNameConfigured
--- End Message ---
--- Begin Message ---
Hi again Muris,
I installed this and it worked fine and seemed to give some reasonable results
back.
You could add it to https://github.com/netdisco/netdisco/wiki/Custom-Reports
perhaps, or I could do that for you?
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: Muris <alcat...@gmail.com>
Sent: 30 July 2024 15:24
To: netdisco-users@lists.sourceforge.net <netdisco-users@lists.sourceforge.net>
Subject: [Netdisco] Addon report - what devices subnets are configured
Hi all,
I made an addon report for showing what subnets are configured on which devices
with their descriptions and vlan ids. This only works well considering the
devices pull all the information in the “Addresses” tab in netdisco user
interface. I had some issues with Nexus MPLS devices, where the vlans don’t
fully show under the “Addresses” tab so if netdisco doesn’t see the subnets it
won’t capture everything (hoping that will be fixed one day)
If you would like to trial it -
Modify the deployment.yml file, find “reports:” on bottom then add it underneath
- tag: SubnetsConfiguredOnDevices
category: IP
label: 'Subnets Configured on Devices'
columns:
- {Subnet: 'Subnet'}
- {Description: 'Description'}
- {VLANID: 'VLAN ID'}
- {DeviceNameConfigured: 'Device Name Configured'}
query: |
SELECT DISTINCT
CAST(s.net AS TEXT) AS Subnet,
dp.name AS Description,
COALESCE(dp.vlan, di.port) AS VLANID,
d.name AS DeviceNameConfigured
FROM
subnets s
JOIN
device_ip di ON s.net = di.subnet
JOIN
device d ON di.ip = d.ip
JOIN
device_port dp ON di.ip = dp.ip AND dp.port LIKE '%lan%' AND dp.port =
di.port
WHERE
s.net IS NOT NULL
ORDER BY
Subnet, Description, VLANID, DeviceNameConfigured
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users
