DX Unified Infrastructure Management

I am trying to create a SQL statement to collect interface bandwidth utilization metrics for several devices that need to be between June 1st and July 31st. I could not use the Top N reports because that only shows the last 30 days of data.

I am not a DBA but I'd like to use this query to try and build a customer report in the I-Report utility but I need to have this statement in order to do so. Any help is greatly appreciated.

Thanks

This might help. Flash portlets have a debug which can capture the sql queries used. The idea is go to the TopN report, enable debug 'Ctrl+/ forward slash', check the box for sql debug, then refresh the report. There is a ladybug icon on the top right to click which opens the debug messages, it is also written in the portal log but it is usually a lot easier to find it in the debug popup window. Once you got the query it should not be that tough to find out to modify it for the needed date range.

david

Perhaps there is a browser configuration preventing popups.

You could try something like this:

select * from V_QOS_INTERFACE_UTILIZATION
where sampletime > '2016-06-01 00:00:00.000'
and sampletime < '2016-07-31 23:59:59.999'

That should give you a starting point. I pulling the data from a view (there is a script in the forums to create them) which makes my query alot easier since I do not have to find the RN table. 

Thanks this is pretty good