NPM Interface utilization report

Question

I need to build an utilization report for about 25 router’s interfaces in one report on NPM version 11.5.1

After I build a  report for one interface I’m trying to use a duplicate option so I can change only the interface number, but when I do it the original interface is changing interface number too.

Can anybody suggest how to use a duplicate option?

Thanks

Igor

jwcp347 · Answer

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-Address

What 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.

vinay.by · Answer

I dont quite understand what exactly you are looking for but I am assuming you are using the Web Reports, if its a simple Interface utilization report you can still create the same using Report Writer (Login into your Solarwinds Server -> Start -> All Programs -> Solarwinds Orion -> Alerting,Reporting, and Mapping -> Report Writer -> Create New Report)

Most of the stats that you require are available here. Hope it helps.