Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Create Custom Table

Hello All,

I am attempting to create a custom table to place on one of my views in Orion. I am wanting to create a table that displays all trunk ports and etherchannel ports within our environment. I have already created a group that does a dynamic query to gather all of those interfaces although I am not certain that is how I should continue to proceed. The table needs to display the following columns (from left to right) Node, Receive % Utilization, Transmit % Utilization, Receive Discards Today, and Transmit Discards Today.

It might also be nice to know how to best break these out by geographic locations if we wanted to.

Please let me know if I need to clarify further or if you have any questions.

Thanks!

Find more posts tagged with

custom chart table

Accepted answers

m-milligan

To find the ContainerID, to to the detail page for the Group, and look at the URL for the page. The URL will end with "NetObject=C:SomeNumber". SomeNumber is the ContainerID. Alternatively, you can modify the query to use the Group name:

SELECT

Interface.Node.Caption as [Node],

Interface.InPercentUtil as [Receive % Utilization],

Interface.OutPercentUtil as [Transmit % Utilization],

Interface.InDiscardsToday as [Receive Discards Today],

Interface.OutDiscardsToday as [Transmit Discards Today]

FROM Orion.NPM.Interfaces Interface

WHERE Interface.InterfaceID IN

(

SELECT CM.MemberPrimaryID

from Orion.ContainerMembers CM

WHERE MemberEntityType='Orion.NPM.Interfaces' AND

CM.Container.Name ='Trunks'

)

ORDER BY Interface.Node.Caption, Interface.Name

All comments

m-milligan

This SWQL query should get you started. YOUR_CONTAINER_ID is the ID of the container that you've created to hold the interfaces.

Interface.Node.Caption as [Node],

Interface.InPercentUtil as [Receive % Utilization],

Interface.OutPercentUtil as [Transmit % Utilization],

Interface.InDiscardsToday as [Receive Discards Today],

Interface.OutDiscardsToday as [Transmit Discards Today]

FROM Orion.NPM.Interfaces Interface

WHERE Interface.InterfaceID IN

(

SELECT CM.MemberPrimaryID

from Orion.ContainerMembers CM

WHERE MemberEntityType='Orion.NPM.Interfaces' AND

CM.ContainerID = YOUR_CONTAINER_ID

)

ORDER BY Interface.Node.Caption, Interface.Name

anthony.cox

Thanks for the input. I am quite the novice in SWQL. What is the easiest way to find the CM.ContainerID? I thought it was simply the name of the group that I created, but I am getting an error stating the *Query is not valid.

Name of the group that I created is simply "trunks" for now. So my query that fails is as follows:

Interface.Node.Caption as [Node],

Interface.InPercentUtil as [Receive % Utilization],

Interface.OutPercentUtil as [Transmit % Utilization],

Interface.InDiscardsToday as [Receive Discards Today],

Interface.OutDiscardsToday as [Transmit Discards Today]

FROM Orion.NPM.Interfaces Interface

WHERE Interface.InterfaceID IN

(

SELECT CM.MemberPrimaryID

from Orion.ContainerMembers CM

WHERE MemberEntityType='Orion.NPM.Interfaces' AND

CM.ContainerID ='Trunks'

)

ORDER BY Interface.Node.Caption, Interface.Name

m-milligan

SELECT

Interface.Node.Caption as [Node],

Interface.InPercentUtil as [Receive % Utilization],

Interface.OutPercentUtil as [Transmit % Utilization],

Interface.InDiscardsToday as [Receive Discards Today],

Interface.OutDiscardsToday as [Transmit Discards Today]

FROM Orion.NPM.Interfaces Interface

WHERE Interface.InterfaceID IN

(

SELECT CM.MemberPrimaryID

from Orion.ContainerMembers CM

WHERE MemberEntityType='Orion.NPM.Interfaces' AND

CM.Container.Name ='Trunks'

)

ORDER BY Interface.Node.Caption, Interface.Name

anthony.cox

I ended up with the following through the UI that I seems to work for what we are looking for. I am still going to attempt to use your m-milligan suggestion from above to try and create a table using the SWQL. Will get back to you once I have tested it.

The settings through GUI are filtering it down to specific interfaces in a specific datacenter.

anthony.cox

I made one additional modification to the query to include the interface name. The results with your method turned out great as well. Thanks for your help!

SELECT

Interface.Node.Caption as [Node],

Interface.Name as [Interface Name],

Interface.InPercentUtil as [Receive % Utilization],

Interface.OutPercentUtil as [Transmit % Utilization],

Interface.InDiscardsToday as [Receive Discards Today],

Interface.OutDiscardsToday as [Transmit Discards Today]

FROM Orion.NPM.Interfaces Interface

WHERE Interface.InterfaceID IN

(

SELECT CM.MemberPrimaryID

from Orion.ContainerMembers CM

WHERE MemberEntityType='Orion.NPM.Interfaces' AND

CM.Container.Name ='Trunks'

)

ORDER BY Interface.Node.Caption, Interface.Name

Anyone reading at a later time, you will need to make sure to create your group first that holds the devices you are looking for.