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.

NTA 95th percentile report

Bobsure over 3 years ago

Hello all,

I have a customer that we sell netflow too and provide support. They have requested a monthly report showing the 95th percentile of bandwidth utilisation.

We have provided 95th % charts which is per interface, unfortunately they do not provide the break down of which IP's behind the interface are taking up the most bandwidth. The customer is happy that they can find out what level of utilisation is being hit but now they would like to understand which IP's specifically are taking up the most traffic so changes can be made to reduce an endpoints consumption.

I've been onto SW support who say this report is not a feature in NTA currently and this would be the best place to ask as some community members may have already customer built a report like this. I had a go at building a report but quite honestly I feel I'm out of my depth a little and unfortunately the customer is pressing for time! As always

Thanks in advance

Top Replies

Parents

0 radekn over 3 years ago

Hello,
Will report below help?
https://thwack.solarwinds.com/t5/NPM-Documents/95th-Percentile-Bandwidth-Utilization-using-Netflow-IPGroups/tac-p/526801
Regards Radek
Cancel
Vote Up +1 Vote Down

Cancel
0 Bobsure over 3 years ago in reply to radekn

Hi Radekn,
Thanks for the reply.
Actually your report was the first I saw but when i tried to load it it endlessly hangs on generating report
I saw further down in the comments on your post that it was no longer working so I thought no point in tshooting the report as others had reported it our of date;
mdingman

‎01-07-2014 09:51 PM
I love this report! But now that NTA went to version 4.0, this report does not work. Is it possible to update this report to use the new NTA Flow Storage database?
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 Bobsure over 3 years ago in reply to radekn

Hi Radekn,
Thanks for the reply.
Actually your report was the first I saw but when i tried to load it it endlessly hangs on generating report
I saw further down in the comments on your post that it was no longer working so I thought no point in tshooting the report as others had reported it our of date;
mdingman

‎01-07-2014 09:51 PM
I love this report! But now that NTA went to version 4.0, this report does not work. Is it possible to update this report to use the new NTA Flow Storage database?
Cancel
Vote Up 0 Vote Down

Cancel

Children

0 radekn over 3 years ago in reply to Bobsure

Hello Bobsure,
The report was modified to run on NTA 4.4 and higher. There is 7 days default time range used inside the report so that's why it probably timeout due to too much of stored flow data.
Please let me know if you need more info.
Regards Radekn
Cancel
Vote Up +1 Vote Down

Cancel
0 Bobsure over 3 years ago in reply to radekn

Thanks again for the help.
Had a look through the "edit report" > "Layout builder".. Do I need to be in editing the 95th Percentile NTA Datasource to change the date range? I've looked but not seeing the field. Or would I need to add a column in the custom table section for a specific time range?
I also just want this for 1 specific customer of ours and thinking this report is currently going through the entire estate (another reason for the timeout) so I was looking into filtering by just 1 group if possible?
Cancel
Vote Up 0 Vote Down

Cancel
0 radekn over 3 years ago in reply to Bobsure

Hello,
The time range has to be modified inside SWQL query. There is also possible to filter only specific IP Group but again only inside the custom query.
Please loot at new report at
https://thwack.solarwinds.com/xcdhs76427/attachments/xcdhs76427/npm-documents/4152/2/+95th+Percentile+IP+Groups+-+last+1+day,8_30-16_30,'Class+A+Private+Addresses'+Ip+Group+-Netflow.xml
This report contains custom SWQL query with filters for default NTA IP group 'Class A Private Addresses' in last 1 day and also filter for example working hours
since 8:30 to 16:30 every day of week.
Custom query SWQL functions are more explained at
https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions
Please let me know you need more info
Regards Radek
Cancel
Vote Up +1 Vote Down

Cancel
0 Bobsure over 3 years ago in reply to radekn

Hi,
I'll take this away and have a look at the links too and let you know.
Thanks again.
Bob
Cancel
Vote Up 0 Vote Down

Cancel