Page 1 of 1
CSV Reporting question
Posted: Thu Sep 24, 2020 10:55 am
by 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'
Re: CSV Reporting question
Posted: Thu Sep 24, 2020 4:24 pm
by scottwilkerson
It is available in the API as well
Help -> API Docs -> Objects Reference -> GET objects/rrdexport
Re: CSV Reporting question
Posted: Fri Sep 25, 2020 12:42 pm
by 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.
Re: CSV Reporting question
Posted: Fri Sep 25, 2020 1:25 pm
by scottwilkerson
wlessard wrote: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
Re: CSV Reporting question
Posted: Fri Sep 25, 2020 1:26 pm
by wlessard
thank you
Re: CSV Reporting question
Posted: Fri Sep 25, 2020 4:25 pm
by scottwilkerson
wlessard wrote:thank you
No problem
Locking thread