Per Port Bandwidth Summary Extract to CSV/XLS

[keryazmi]

Hi,

Sorry for asking help. Is there any way to extract the info as per graph above?

For example, on one week period graph, with extract button and convert the details on bandwidth summary per port into csv/xlsx file. Maybe the detail require to extract are Port Description, Bandwidth Now, Bandwidth Average, Bandwidth Maximum and 95% Percentile.

Appreciate your kind feedback.

[zombah]

Hello,
There is alot tools which converts RRD files to other formats and also csv, so you can use the one that suits your needs, like rrddump or rrdxport which dumps rrd data into xml.

[keryazmi]

Hi,

Thanks for the idea.

However, I am prefer if there is a button which can extract those data. Since LibreNMS can create user account under normal which is not Administrator. Specifically for customer/client whose can’t access directly to LibreNMS server.

It may be difficult every time client require the data and IT Admin need to access the server in order to create data by using rrdxport or rrddump.

I am currently work with the provider, it would be beautiful if LibreNMS have this feature. Since most of the user require to provide a bandwidth report before they upgrade the bandwidth with the provider.

Thanks.

[zombah]

Then I don’t quite undestand your feature request idea, if just convert rrd to digits thats possible with external tools, if you need interface report check billing module

[keryazmi]

I tried the billing module and it is really good feature.

For example, I have Customer A with multiple port or Service ID.
For some reason, Customer A require to extract specific port to csv/pdf which it cannot be done due to the billing module only display all ports summary bandwidth usage.

Maybe we need to improve the billing module which can extract to the csv/pdf which Customer A can select which ports/Service ID they require.

Thanks for the feedback.

[zombah]

You can create as many bills as you want with different port combos

[keryazmi]

Yes. But still can’t extract to CSV/XLS file type.

[zombah]

You can get it with get_bill_graphdata api endpoint and render it to any format you want.

[keryazmi]

Can you suggest suitable application to do this? Since I am not familiar with API… Thanks

[zombah]

Try easiest one curl -X GET ... | jq -r '.. | @csv' then you can replicate this with any programming language of your choice to do more beautiful things.