Return current Netflow data via SQL

Question

I can set the NTA 'Charting and Graphing Settings' to display the last 5 minutes of Netflow data but I cant seem to do the same with my sql statement. i.e. my sql statement only works if my time range is the past hour or more. The table i'm querying Is 'Orion.Netflow.Flowsbyconversation' so maybe that does not hold current hours Netflow data? Hopefully someone can point out the issue or what I'm doing wrong Example: Current Time 13:20 time range set to: '5 min windows within the last hour', zero rows are returned TimeStamp > '2018-05-10T13:00:00' AND TimeStamp <= '2018-05-10T13:05:00' time range set to: 'last hour', rows returned OK TimeStamp > '2018-05-10T12:20:00' AND TimeStamp <= '2018-05-10T13:20:00' time range set to: '5 min windows but not in current hour', rows returned OK TimeStamp > '2018-05-10T11:20:00' AND TimeStamp <= '2018-05-10T11:25:00' NTA - Charting and Graphing Settings Default time period for resources placed on DETAIL views is: Last Minutes Hours Days Months Default time period for resources placed on SUMMARY views is: Last Minutes Hours Days Months NTA - Charting and Graphing Settings

bad93r · Answer

Hi Chad.every - good to know re. move to sql 2016, although if a wait for this I'm then reliant on an NTA upgrade and sql 2016 install before I can test again whereas my query is all written I just cant seem to report back on current Netflows.

chad.every · Answer

Honestly, you might want to wait on the query side if you can, otherwise you'll have to redo your work soon. The next version of NTA is moving away from the current Flow Storage Database (FSDB) and into Microsoft SQL. That roadmap is shown here: https://thwack.solarwinds.com/docs/DOC-176988#start=25