[Netdisco] report for number of ports connected at 10/100/1000 ?

Discussion:

Joseph Bernard

2014-10-08 14:32:32 UTC

I’m running Netdisco 1.1 at the moment. How hard would it be to make a report to show me the number of connected ports at 10Mbps, at 100Mbps, and at 1000Mbps? I just need the counts. I can install Netdisco 2 if it would be way easier to do this kind of thing with that.

Thanks,
Joseph B.

Joseph Bernard

2014-10-08 16:29:49 UTC

Permalink

That is perfect! I have exactly what I need.

Thanks!
Joseph B.

If you know SQL then doing ad-hoc reports in netdisco is super easy
select count(*), speed from device_port where up = 'up' group by speed;
That's the result of 2 minutes work, so anyone feel free to correct me if I'm wrong
-Brian Marshall

Post by Joseph Bernard
I’m running Netdisco 1.1 at the moment. How hard would it be to make a report to show me the number of connected ports at 10Mbps, at 100Mbps, and at 1000Mbps? I just need the counts. I can install Netdisco 2 if it would be way easier to do this kind of thing with that.
Thanks,
Joseph B.
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Netdisco mailing list
https://lists.sourceforge.net/lists/listinfo/netdisco-users

Oliver Gorwits

2014-10-09 12:36:17 UTC

Permalink

Thanks Brian :-)

For the benefit of those following who've not used Netdisco 2's custom
reports feature, below is the config to add to the main configuration
file, and then a new "Port Speeds" report will automagically appear in
the menu:

reports:
- tag: port_speeds
label: 'Port Speeds'
columns:
- {total: 'Count'}
- {speed: 'Speed'}
query: |
SELECT count(*) AS total, speed
FROM device_port
WHERE up = 'up'
GROUP BY speed
ORDER BY total

As easy as that!

https://metacpan.org/pod/distribution/App-Netdisco/lib/App/Netdisco/Manual/Configuration.pod#reports

regards,
oliver.

Post by Joseph Bernard
That is perfect! I have exactly what I need.
Thanks!
Joseph B.

If you know SQL then doing ad-hoc reports in netdisco is super easy
go into your postgres database with psql (eg. "psql netdisco
select count(*), speed from device_port where up = 'up' group by speed;
That's the result of 2 minutes work, so anyone feel free to correct me if I'm wrong
-Brian Marshall

Post by Joseph Bernard
I’m running Netdisco 1.1 at the moment. How hard would it be to
make a report to show me the number of connected ports at 10Mbps, at
100Mbps, and at 1000Mbps? I just need the counts. I can install
Netdisco 2 if it would be way easier to do this kind of thing with
that.
Thanks,
Joseph B.
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog
Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Netdisco mailing list
https://lists.sourceforge.net/lists/listinfo/netdisco-users

Deshong, Kenneth

2014-10-09 15:51:26 UTC

Permalink

Thanks for this report, this will come in handy. I ran the report but I show a lot of weird speeds. Do you know why my report shows as such...

Count Speed
2 200000000
7 4000000000
8 20 Gbps
10 3000000000
16 1410065408
58 10 Gbps
62 2000000000
572 10 Mbps
1209
3439 1.0 Gbps
4830 100 Mbps

Ken DeShong
Network Engineer

Amazing Things Happen When You Connect the Unconnected

-----Original Message-----
From: Oliver Gorwits [mailto:***@cpan.org]
Sent: Thursday, October 09, 2014 8:36 AM
To: netdisco-***@lists.sourceforge.net
Subject: Re: [Netdisco] report for number of ports connected at 10/100/1000 ?

Thanks Brian :-)

For the benefit of those following who've not used Netdisco 2's custom reports feature, below is the config to add to the main configuration file, and then a new "Port Speeds" report will automagically appear in the menu:

reports:
- tag: port_speeds
label: 'Port Speeds'
columns:
- {total: 'Count'}
- {speed: 'Speed'}
query: |
SELECT count(*) AS total, speed
FROM device_port
WHERE up = 'up'
GROUP BY speed
ORDER BY total

As easy as that!

https://metacpan.org/pod/distribution/App-Netdisco/lib/App/Netdisco/Manual/Configuration.pod#reports

regards,
oliver.

Post by Joseph Bernard
That is perfect! I have exactly what I need.
Thanks!
Joseph B.

Post by Joseph Bernard
I’m running Netdisco 1.1 at the moment. How hard would it be to
make a report to show me the number of connected ports at 10Mbps, at
100Mbps, and at 1000Mbps? I just need the counts. I can install
Netdisco 2 if it would be way easier to do this kind of thing with
that.
Thanks,
Joseph B.
--------------------------------------------------------------------
---------- Meet PCI DSS 3.0 Compliance Requirements with EventLog
Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box
PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance?
Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5
with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ost
g.clktrk _______________________________________________
Netdisco mailing list
https://lists.sourceforge.net/lists/listinfo/netdisco-users

Joseph Bernard

2014-10-09 15:58:20 UTC

Permalink

Some of the ports are virtual or non-ethernet. I had to add “AND type = 'ethernetCsmacd’ “ to my queries to get what I was looking for.

Thanks,
Joseph B.

Post by Deshong, Kenneth
Thanks for this report, this will come in handy. I ran the report but I show a lot of weird speeds. Do you know why my report shows as such...
Count Speed
2 200000000
7 4000000000
8 20 Gbps
10 3000000000
16 1410065408
58 10 Gbps
62 2000000000
572 10 Mbps
1209
3439 1.0 Gbps
4830 100 Mbps
Ken DeShong
Network Engineer
Amazing Things Happen When You Connect the Unconnected
-----Original Message-----
Sent: Thursday, October 09, 2014 8:36 AM
Subject: Re: [Netdisco] report for number of ports connected at 10/100/1000 ?
Thanks Brian :-)
- tag: port_speeds
label: 'Port Speeds'
- {total: 'Count'}
- {speed: 'Speed'}
query: |
SELECT count(*) AS total, speed
FROM device_port
WHERE up = 'up'
GROUP BY speed
ORDER BY total
As easy as that!
https://metacpan.org/pod/distribution/App-Netdisco/lib/App/Netdisco/Manual/Configuration.pod#reports
regards,
oliver.

Post by Joseph Bernard
That is perfect! I have exactly what I need.
Thanks!
Joseph B.

Post by Joseph Bernard
I’m running Netdisco 1.1 at the moment. How hard would it be to
make a report to show me the number of connected ports at 10Mbps, at
100Mbps, and at 1000Mbps? I just need the counts. I can install
Netdisco 2 if it would be way easier to do this kind of thing with
that.
Thanks,
Joseph B.
--------------------------------------------------------------------
---------- Meet PCI DSS 3.0 Compliance Requirements with EventLog
Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box
PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance?
Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5
with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ost
g.clktrk _______________________________________________
Netdisco mailing list
https://lists.sourceforge.net/lists/listinfo/netdisco-users

------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Netdisco mailing list
https://lists.sourceforge.net/lists/listinfo/netdisco-users
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Netdisco mailing list
https://lists.sourceforge.net/lists/listinfo/netdisco-users

Mark Cooper

2014-10-09 15:57:34 UTC

Permalink

More than likely it is logical interface (virtual ones), like an SVI for example.

Thanks,Mark Cooper

*Cooper's Communications*
***@coopscommo.com

--------------------
/This e-mail and the information it contains is privileged and/or confidential. It is for the intended addressee(s) only. Any unauthorized use, copying, distribution, disclosure or retention of this e-mail, or any information it contains, is prohibited and could be a criminal offense under the 'insert applicable Act here'. If you are not an intended recipient, please destroy this message and notify the sender immediately./

Post by Joseph Bernard
That is perfect! I have exactly what I need.
Thanks!
Joseph B.

Iâm running Netdisco 1.1 at the moment. How hard would it be to
make a report to show me the number of connected ports at 10Mbps, at
100Mbps, and at 1000Mbps? I just need the counts. I can install
Netdisco 2 if it would be way easier to do this kind of thing with
that.
Thanks,
Joseph B.
--------------------------------------------------------------------
---------- Meet PCI DSS 3.0 Compliance Requirements with EventLog
Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box
PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance?
Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5
with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ost
g.clktrk _______________________________________________
Netdisco mailing list
https://lists.sourceforge.net/lists/listinfo/netdisco-users