[influxdb] Subquery Help !

2017-02-14 Thread kmg
I just came to know the newer version of Influxdb supports subquery. I tried to add this feature into my existing architecture, But it shows null value[Emptry output]. Could someone please help me whats wrong here. Does subquery only work on select operations ? SubQuery I tried : SELECT

[influxdb] Re: Subquery Help !

2017-02-15 Thread kmg
Any help on this please ? On Tuesday, 14 February 2017 19:00:38 UTC+5:30, kmg wrote: > > I just came to know the newer version of Influxdb supports subquery. I > tried to add this feature into my existing architecture, But it shows null > value[Emptry output]. Could someone please h

[influxdb] Query not working

2016-09-23 Thread kmg
Someone please help me on the below query. its not running. Is that function not supported in Influxdb or did I make anything wrong in the query syntax ? SELECT mean("sensor") FROM sensor WHERE hostname = 'www.dev.local' AND sensor_type = 'lmsensors' AND sensor_class = 'temperature' AND

[influxdb] Re: Telegraf Cloudwatch metrics

2016-10-14 Thread kmg
Any idea on this ?. I'm not sure whether its a bug on the plugin On Wednesday, 12 October 2016 11:39:50 UTC+5:30, kmg wrote: > > I tried to pull AWS metrics through cloudwatch using telegraf and write > the output data into influxdb. > > When I run the test with sample config, it

[influxdb] Telegraf Cloudwatch metrics

2016-10-12 Thread kmg
I tried to pull AWS metrics through cloudwatch using telegraf and write the output data into influxdb. When I run the test with sample config, it shows only EC2 stats . Not showing anything else. For example, If I set the namespace to "AWS/EC2", then run the below command, ]# telegraf

[influxdb] Re: CPU usage Query !

2016-12-09 Thread kmg
I would like to know whether its possible to do the above mentioned calculation. Kindly help on this. Since I got stuck at this point in production environment. On Friday, 2 December 2016 17:11:20 UTC+5:30, kmg wrote: > > > I checked the docs and tried multiple queries. Final

[influxdb] Re: CPU usage Query !

2016-12-02 Thread kmg
'2016-09-18T22:47:53.408149394Z' and time < '2016-09-18T22:52:53.531283581Z' group by time(5m) Kindly someone help me on this On Thursday, 1 December 2016 18:55:03 UTC+5:30, kmg wrote: > > I'm new to influxdb. I tried to calculate the CPU usage. > > Data inserted into influxdb with

[influxdb] CPU usage Query !

2016-12-01 Thread kmg
I'm new to influxdb. I tried to calculate the CPU usage. Data inserted into influxdb with 5mins interval. my Calculation for Every 5mins: CPU_usage = [ ssCpuRawUser / (ssCpuRawUser+ssCpuRawNice+ssCpuRawSystem+ssCpuRawIdle+ssCpuRawSoftIRQ) ] * 100 Please share me the query for the above