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: Netdisco Reports question (Jethro Binks)
--- Begin Message ---
I've updated the custom reports page with another sample and tried to make it
all a bit clearer.
https://github.com/netdisco/netdisco/wiki/Custom-Reports
Of course Oliver might like them so much he puts them into the system reports
...
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: Oliver Gorwits <[email protected]>
Sent: 08 March 2023 09:52
To: Sanjeev Gupta <[email protected]>; [email protected]
<[email protected]>
Subject: Re: [Netdisco] Netdisco Reports question
Hi Sanjeev,
I try to add interesting reports to Netdisco itself. For this one it's now
committed for the next release:
https://github.com/netdisco/netdisco/commit/3ee0c7692c48d78281a869f1d0fd722cb8c96039
However it's a great idea to also have a wiki page maybe in the Netdisco wiki
for community report suggestions. If people can't edit that, they can open an
issue to submit:
https://github.com/netdisco/netdisco/issues/new
regards
Oliver
On Wed, 8 Mar 2023 at 05:04, Sanjeev Gupta
<[email protected]<mailto:[email protected]>> wrote:
Thank you, nifty!
Oliver, is there a place these can be archived? For the benefit of those who
come late to the party?
If nothing else, https://en.wikipedia.org/wiki/User:Oliver ?
--
Sanjeev Gupta
+65 98551208 http://sg.linkedin.com/in/ghane
On Tue, Mar 7, 2023 at 5:48 PM Muris
<[email protected]<mailto:[email protected]>> wrote:
Hey all I managed to get this to work, a space was the issue, it’s quite picky
how you space it out, here is a report I’ve done for this which reports devices
added into netdisco the past 2 months sorted by latest date, this is added into
the deployment.yml file under reports section, then at the top you will get an
extra menu in the web interface under Device > Recent Devices added past 2
months
reports:
- tag: recent
category: Device
label: 'Recent Devices Added Past 2 months'
columns:
- {ip: 'Device IP'}
- {name: 'Device Name'}
- {creation: 'Date Added'}
- {location: 'Location'}
- {contact: 'Contact'}
- {serial: 'Serial'}
- {model: 'Model'}
- {vendor: 'Vendor'}
- {os: 'Operating System'}
- {os_ver: 'OS Version'}
query: |
SELECT ip AS ip, name AS name, creation AS creation, location AS
location, contact AS contact, serial AS serial, model AS model, vendor AS
vendor, os AS os, os_ver AS os_ver
FROM device
WHERE creation > now() - interval '8 weeks'
ORDER BY creation DESC
From: Muris <[email protected]<mailto:[email protected]>>
Date: Tuesday, 28 February 2023 at 23:06
To:
"[email protected]<mailto:[email protected]>"
<[email protected]<mailto:[email protected]>>
Subject: Netdisco Reports question
Hi,
Im trying to do a web report for the following SQL query which lists devices
recently added into net disco for past 2 weeks
netdisco-do psql -e "select ip, name from device where creation > now() -
interval '2 weeks'"
In the deployment YML I have something like this, which doesn’t work, any ideas?
- tag: recent
label: 'Recent Devices Added past 2 weeks'
category: Device
columns:
- {ip: 'Device IP'}
- {name: 'Device Name'}
query: |
SELECT ip, name,
FROM device
WHERE creation > now() - interval '2 weeks'
ORDER by name
_______________________________________________
Netdisco mailing list
[email protected]<mailto:[email protected]>
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
_______________________________________________
Netdisco mailing list
[email protected]<mailto:[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
