This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Interface(s) Availability Report needed ASAP

TXNOGAS over 14 years ago

Needing assistance on creating a Interface Availability Report for the following specific interfaces on Nodes ONLY:

Report would include NodeName, InterfaceName, Availability in %, Downtime Duration in min. for the previous month, but specific for ONLY the following Nodes & Interfaces,,,

Example:

NodeName: InterfaceName: Availability (%): Downtime Duration (min):

DFW11gw Fe4 98.999% 14 min.

DFW11sw Fe0/24 98.997% 14 min.

WANGW1 Fe0/1.2453 (this one is a sub interface) 97.999% 21 min.

WANGW1 Ge0/1 97.999% 21 min.

Thanks in advance for your help,,,

0 lag over 14 years ago

In Report Writer, in the filters for the report, filter by ANY where you then list out the nodes by name that you want, or if you're using custom properties to group your nodes, you can filter on custom property instead of listing out each node you want in the report.
Cancel
Vote Up 0 Vote Down

Cancel
0 TXNOGAS over 14 years ago in reply to lag

I need this report to look like my example,,,
Where it has the Node Name, Interface Name, Availability in % then Downtime Duration in (min.) for the previous month,,,

Example:
NodeName:     InterfaceName:     Availability (%):     Downtime Duration (min):
DFW11gw             Fe4                        98.999%              14 min.
DFW11sw             Fe0/24                   98.997%                14 min.
WANGW1              Fe0/1.2453 (this one is a sub interface)            97.999%                21 min.
WANGW1              Ge0/1                     97.999%                 21 min.
Cancel
Vote Up 0 Vote Down

Cancel
0 sotherls over 14 years ago in reply to TXNOGAS

Just posted a modified report for you in Content Exchange.
See if this works for you.
Cancel
Vote Up 0 Vote Down

Cancel
0 TXNOGAS over 14 years ago in reply to sotherls

I'm receiving the following error:???
- error.JPG
- View
- Hide
Cancel
Vote Up 0 Vote Down

Cancel
0 ecklerwr1 over 14 years ago in reply to TXNOGAS

I tried the report also and got the same error. I then tried editing SQL to use OrionNetPerfMon instead of NetPerfMon and tried the query... I ended up killing it because it seemed to be taking an extended period of time to run.
EDIT:
sotherls can probably shed some light...
Cancel
Vote Up 0 Vote Down

Cancel
0 sotherls over 14 years ago in reply to ecklerwr1

What is the SQL name of your database? The report assumes it is NetPerfMon.
I think it might also be that the code I snipped might require that the user be able to create a temp table.
Cancel
Vote Up 0 Vote Down

Cancel
0 ecklerwr1 over 14 years ago in reply to sotherls

My is the default that was loaded when NPM was installed. Is this what you mean?
Cancel
Vote Up 0 Vote Down

Cancel
0 sotherls over 14 years ago in reply to ecklerwr1

Try the new one I posted up there for you.
Cancel
Vote Up 0 Vote Down

Cancel
0 ecklerwr1 over 14 years ago in reply to sotherls

How long should it take to run? I did the same thing I think and changed use netperfmon to Orionnetperfmon and then ran the query from report writer... it goes to Querying database... and just sits there with the hourglass. I'll let it run for while... maybe someone else can test also. Is it supposed to run quickly or take a while?
Cancel
Vote Up 0 Vote Down

Cancel
0 ecklerwr1 over 14 years ago in reply to sotherls

Hmmmm interesting I tried copying the query into SQL Server Management Studio and running the query there. It works fine an returns almost immediately using use OrionNetPerfMon. Seems like if it works in there it would work in report writer also. I wonder if it has something to do with the version I'm using? Seems like it shouldn't.
Cancel
Vote Up 0 Vote Down

Cancel