Is it possible to create a switch port utilization report? I don't mean port bandwidth utilization, but actual ports in-use. For instance, I want to see if switches are near capacity because they have some percentage of their ports up/up.
TIA,
Eric
Shameless plug, but we do this by default in UDT: http://oriondemo.solarwinds.com/Orion/UDT/Summary.aspx
So I know this is an old thread but, I just wanted to offer my solution. I have weekly reports that I create using the following column identifiers in a Custom Solarwinds Report :
1. Node Name
2. Interface Name
3. Interfaced Index
4. Speed
5. Country
6. Location Code
7. IP Address
8. Interface Type Description
9. Last Status Change
10. Administrative Status
11. Operational Status
12. Last Polled
13. Machine Type
14. MAC-AddressWhat I then do is utilize these formulas in Excel in order to be able to get the information that I want on a per node basis:
Port Count : =COUNTIF('Sheet_Name1'!Range of Node Names from Report,'Sheet_Name2'!Node_Name_Cell)
In this case the 1st sheet is my full report and the second sheet is where I have removed any duplicates in terms of node names and added Port count Up down Used and Unused columns
Up Status: =COUNTIFS('Sheet_Name1'!Range of Node Names from Report,'Sheet_Name2'!Node_Name_Cell,'Sheet_Name1'!Operational_Status_Column,"Up")
This gives me a count for all ports that have an operational status of UP
Potenitally Used Port (Less than 30 days downtime) : =COUNTIFS('ISheet_Name1'!Range of node names From Report,'Sheet_Name2'!Node_Name_Cell,'Sheet_Name1'!Operational Status Column,{"Down","Unplugged"},'Sheet_Name1'!Status Change Date,">"&TODAY()-30)
This gives me a count for all ports whose status has changed withing the last 30 days to "Down" or "Unplugged
These are the formulas that I use. It was a bit of work upfront but, it's all copy and paste now. The only thing you need to do is reconcile IPs with a side by side comparison and make the necessary row inserts or deletions to accommodate.
=COUNTIF('Port Utilization (Global)'!B:B,'Device Utilization'!B2)
=COUNTIFS('Port Utilization (Global)'!B:B,'Device Utilization'!B2,'Port Utilization (Global)'!K:K,"Up")
=COUNTIFS('Port Utilization (Global)'!B:B,'Device Utilization'!B2,'Port Utilization (Global)'!K:K,{"Down","Unplugged"},'Port Utilization (Global)'!I:I,">"&TODAY()-30)
Range B:B is my Node name Column
B2 would be the node I want to see port utilization statistics on
K:K is my Operational Status Column
I:I is my Last Status Change Column
If someone has a simpler, more automated mechanism to do this, it would be greatly appreciated. This is working for me for now though, I get weekly percentages for individual nodes and can color code and make changes as they are necessary.
UDT certainly provides the real-time numbers but, it also would determine a port down if at the moment you run the report someone has unplugged their device. Perhaps there is a way to change that threshold but, I have yet to find it.
