CSV Reporting question

[wlessard]

I would like to pull the below metrics to a csv file daily. The only way I have researched is running the report and going to each graph and click "download csv"

Is there another way to pull this data automatically?

'timestamp' 'cpu_usage'
'1600837500' '5.9537800000e+00'
'1600837800' '8.2597800000e+00'
'1600838100' '5.1587200000e+00'
'1600838400' '1.4818600000e+00'
'1600838700' '1.2210733333e+00'
'1600839000' '1.1803666667e+00'
'1600839300' '1.3470400000e+00'
'1600839600' '1.8929400000e+00'
'1600839900' '1.2455200000e+00'
'1600840200' '1.3702800000e+00'

[scottwilkerson]

It is available in the API as well
Help -> API Docs -> Objects Reference -> GET objects/rrdexport

[wlessard]

thank you for that.

Another question on csv data.

When i do a export CSV for CPU the data is does not look correct

timestamp 'cpu_prct_used'
1600407000 '2.4094298611e+01'
1600408800 '2.4890398148e+01'
1600410600 '2.7666976852e+01'
1600412400 '1.9913092593e+01'

Shouldnt they be percentage? Also the data is not correct corresponding to the graph. look at graph or example.

[scottwilkerson]

thank you for that.

Another question on csv data.

When i do a export CSV for CPU the data is does not look correct

timestamp 'cpu_prct_used'
1600407000 '2.4094298611e+01'
1600408800 '2.4890398148e+01'
1600410600 '2.7666976852e+01'
1600412400 '1.9913092593e+01'

Shouldnt they be percentage? Also the data is not correct corresponding to the graph. look at graph or example.

These are the values. RRD stores them on E notation and that is what is exported
https://en.wikipedia.org/wiki/Scientifi ... E_notation

[wlessard]

thank you

[scottwilkerson]

thank you

No problem

Locking thread