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: 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 <oli...@cpan.org>
Sent: 08 March 2023 09:52
To: Sanjeev Gupta <sanj...@dcs1.biz>; netdisco-users@lists.sourceforge.net
<netdisco-users@lists.sourceforge.net>
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
<sanj...@dcs1.biz<mailto:sanj...@dcs1.biz>> 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
<alcat...@gmail.com<mailto:alcat...@gmail.com>> 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 <alcat...@gmail.com<mailto:alcat...@gmail.com>>
Date: Tuesday, 28 February 2023 at 23:06
To:
"netdisco-users@lists.sourceforge.net<mailto:netdisco-users@lists.sourceforge.net>"
<netdisco-users@lists.sourceforge.net<mailto:netdisco-users@lists.sourceforge.net>>
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
netdisco-users@lists.sourceforge.net<mailto:netdisco-users@lists.sourceforge.net>
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
_______________________________________________
Netdisco mailing list
netdisco-users@lists.sourceforge.net<mailto: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
