Aggregate NodeID totals in report

I've been having trouble with editing my current query to get the total of all interfaces and interfaceID's associated with a single nodeID to show on one row.

interfaceID

nodeID

More specifically, I want to get the sum of the MAXIMUM INPUT BPS (90), MAXIMUM INPUT BPS (95), MAXIMUM INPUT BPS (99), and other relevant columns. For instance, for nodeID = 113, there are multiple interfaceID's associated to that nodeID and therefore will output the results to have multiple rows for nodeID = 113.

MAXIMUM INPUT BPS (90)

MAXIMUM INPUT BPS (95)

MAXIMUM INPUT BPS (99)

nodeID = 113

interfaceID

nodeID

nodeID = 113

What I want to do is get the sum of the MAXIMUM INPUT BPS (90) and other numerical columns to be displayed in one singular row for nodeID = 113 and show the numerical outputs (I'm fine with removing the interfaceID's and interface name columns).

MAXIMUM INPUT BPS (90)

nodeID = 113

interfaceID

I'll be attaching an image of the current report to help clear things up for what I have now based off of the query I have written:

Any suggestions would be great. Thank you!

1 Answer
1

SolarWinds Query Language (SWQL) supports aggregate functions such as SUM that you can use here to obtain the result that you are looking for.

SELECT NodeID, SUM([MAX INPUT BPS(90)])
FROM
<TableName>
GROUP BY NodeID


Please let me know if this helps answer your question.

To see what's supported by SWQL, you can visit this page

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.