Or perhaps better

show last(temp) from machines where time > now() - 1d

On Thursday, February 22, 2018 at 10:03:26 AM UTC-6, Frank Inselbuch wrote:
> I don't believe that can be done.
> What you can do is query the measurement for a field value with a 
> timestamp in the last day.
> For example
> select temp from machines where time > now() - 1d
> But you have to specify the measurement in the query.
> You could construct these queries for all measurements in a program (bash, 
> python, etc.) ... run show measurements to get the whole list of 
> measurements.
> Then construct the above query for each measurement.
> Not ideal, I know.
> On Tuesday, February 13, 2018 at 1:11:11 PM UTC-6, Travis Keep wrote:
>> > show measurements
>> This shows all the measurements in a database, but I am interested in 
>> only the measurements that are newer than 1 day.  If the measurement did 
>> not exist 1 day ago, I don't want it listed.  How would one write such a 
>> query?

Remember to include the version number!
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
For more options, visit https://groups.google.com/d/optout.

Reply via email to