> How to select all records that are 10 minutes within current timestamp in influxdb?
SELECT * FROM foo WHERE time > now() - 10m For monitoring whether something has been in a particular state for 10m or more, I would recommend using Kapacitor: https://docs.influxdata.com/kapacitor/v0.13/introduction/getting_started/. It's a monitoring tool built to work with InfluxDB. On Tue, Jul 19, 2016 at 11:30 PM, <[email protected]> wrote: > How to select all records that are 10 minutes within current timestamp in > influxdb? For instance, I have data coming in and i need to check if a > particular message/data is stuck in failed status for more than 10 minutes. > Appreciate all suggestions. > > -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to the Google Groups > "InfluxDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit > https://groups.google.com/d/msgid/influxdb/e8b37943-c135-4ffc-bbf5-fd7fd9507706%40googlegroups.com > . > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvM2-xvUxpNXoeuRoQzdzBOzjD0MVw8Ghsq0SMRGsUH2nA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
