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: SQL Query For Free Ports (Jason Garrett)
--- Begin Message ---
That was perfect! Thanks!
Thanks!
Jason Garrett
Diocese of Lincoln Schools
Education Technology: (402) 473-0600
Email: [email protected]
-----Original Message-----
From: Christian Ramseyer <[email protected]>
Sent: Wednesday, January 20, 2021 4:59 PM
To: Jason Garrett <[email protected]>;
[email protected]
Subject: Re: [Netdisco] SQL Query For Free Ports
Hi Jason
You can find an example query in here:
<https://github.com/netdisco/netdisco/blob/master/lib/App/Netdisco/DB/Result/Virtual/PortUtilization.pm>
This seems to pretty much do what you're looking for, otherwise let us know.
Cheers
Christian
On 20.01.21 18:44, Jason Garrett wrote:
> I'm trying to determine what database fields NETDISCO is using to
> determine the Free status that can be seen in the web interface. I
> found 'lastchange' in public.device_port but I can't figure out
> exactly how that correlates or is calculated.
>
>
>
> Ultimately I would like a SQL query that shows me each switch, switch
> uptime, and the number of free ports where free is determined by the
> port either not being used since switch was last rebooted, or port not
> used in last 6 months if uptime is greater than 6 months.
>
> Thanks!
>
> Jason Garrett
>
> Diocese of Lincoln Schools
>
> Email: [email protected] <mailto:[email protected]>
>
>
>
>
>
> _______________________________________________
> 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
