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.

Need the SQL for a report

I have a report in NPM that selects datasource based on the interface alias (say if alias contains MPLS) and Total Average percent utilization is greater than or equal to 80

Capture.PNG

 

The result table must have the details like the total bps.

Capture.PNG

And I am looking for the data for last 7 days.

I can create this in Solarwinds. but i want a equivalent SQL for this report , which can be run from the SQL manager.

I am not able to get the proper db tables.