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. How to set up a SQL query to filter on all physical Ethernet
switch ports? (Gerlach Tobias DLN FIII31)
--- Begin Message ---
Hello all,
My current challenge is to report all physical Ethernet switch ports.
So far I used the ifType "ethernetCsmacd" from the interfaces MIB (IF-MIB,
http://www.net-snmp.org/docs/mibs/interfaces.html) as Ethernet is the only
relevant protocol.
However, the result looks a bit odd and there's a lot of other interface types
(ifType, http://www.net-snmp.org/docs/mibs/interfaces.html#IANAifType) and it's
probably up to the vendors to correctly populate this table.
Any ideas on how to achieve this demand most accurately?
$ netdisco-do psql -e "select speed, count(*) from device_port where type like
'ethernetCsmacd' group by speed"
[35929] 2020-11-12 14:31:01 info App::Netdisco version 2.046002 loaded.
[35929] 2020-11-12 14:31:01 info psql: started at Thu Nov 12 15:31:01 2020
speed | count
------------+--------
0 | 53782
1 | 717
100 | 25
1000 | 77
10000 | 113
1000000 | 1
100 Gbps | 456
100 Mbps | 80311
1.0 Gbps | 166875
10 Gbps | 30701
10 Mbps | 107699
1113 Tbps | 356
1410065408 | 11
15000000 | 5
16 Mbps | 1
200 Mbps | 2
20480000 | 1
2.0 Mbps | 5
20 Mbps | 12
23000 | 146
25000000 | 3
2500000000 | 9
25 Gbps | 1279
3000000 | 2
30000000 | 3
3209 Tbps | 82
40000000 | 1
400 Mbps | 2
40 Gbps | 2169
4.0 Mbps | 18
4294967295 | 83
4294 Tbps | 28
5000000 | 12
50000000 | 11
500000000 | 1
5.0 Gbps | 85
54 Mbps | 1
56418000 | 3
6000000 | 12
65 Gbps | 3
8000000 | 8
94030000 | 1
| 3455
(43 rows)
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users
