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: Performance issue for big queries in My Reports
(Oliver Gorwits)
--- Begin Message ---
Hi Markus
We need a list of all "real" end user ports (not the trunks between
switches, not any internal interfaces, ...) and give the user the
ability to filter the list for e.g. VLAN-ID, location/dns-name, so the
Thanks for your SQL and also description of what you are trying to
achieve.
I have taken the opportunity to enhance the built in ports search, with
some of your ideas, such as restricting to Ethernet ports and adding
some columns. Maybe this will be useful for you, or not, but I think it
will help others.
This will be in the next release.
regards
Oliver.
On 2017-12-06 05:46, Markus Drexelius wrote:
Hi,
here is the select statement we are using in the moment:
SELECT device.dns, device_port.port, device_port.vlan,
device_port.lastchange, device_port.up, device_port.up_admin,
device_port.speed, device_port.name FROM device_port LEFT JOIN device
ON device_port.ip = device.ip WHERE (((device_port.port) Not Like
'Vlan*') AND ((device_port.type) Like 'ethernetCsmacd') AND
((device_port.is_uplink) Is Null)) ORDER BY device.dns;
On command line / database level the query needs about only 2-3
seconds, so I think the performance issue is in the level above (perl
module / jquery on client side) as Oliver already mentioned...
We need a list of all "real" end user ports (not the trunks between
switches, not any internal interfaces, ...) and give the user the
ability to filter the list for e.g. VLAN-ID, location/dns-name, so the
built in reports/functions does not work very good for this, because
all the internal uplinks/ports are displayed and not only the enduser
ports for example...
Thanks a lot for your help,
best regards
Markus
GESENDET: Dienstag, 05. Dezember 2017 um 15:08 Uhr
VON: "Andy Ruhl" <[email protected]>
AN: "[email protected]"
<[email protected]>
BETREFF: Re: [Netdisco] Performance issue for big queries in My
Reports
Does the query come back in a reasonable amount of time from the
command line in the database?
Use netdisco-do psql to get a command line.
Also, I have a lot of ports, more than 60k. I'd be interested to see
how the query runs on my system.
Andy
On Mon, Dec 4, 2017 at 11:47 PM, Markus Drexelius <[email protected]>
wrote:
> Hello,
>
> we want to implement a user defined report under "My Reports" with
a list of
> any LAN ports in our networks in netdisco2.
>
> For that I have created an SQL query: the result set is about
60.000 records
> (ports) to be displayed.
>
> Netdisco seems not to able to display such a high amount of records
due to
> performance issues: it needs more than 1 minute to load the
report....
>
> Is there any possibility to increase the performance to an user
friendly
> amount of time? (e.g. several seconds to load)
>
> Thanks
>
> markus
>
>
------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot [1]
> _______________________________________________
> Netdisco mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/netdisco-users [2]
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot [1]
_______________________________________________
Netdisco mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users [2]
Links:
------
[1] http://sdm.link/slashdot
[2] https://lists.sourceforge.net/lists/listinfo/netdisco-users
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Netdisco mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
--- End Message ---
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
