topic Re: Adding running time in the query in Alerting

Adding running time in the query

Kwip — Tue, 04 Apr 2017 11:52:24 GMT

I need to set up alert for one of my query.
I will be setting it to run for every 1 hour. But when its running on every one hour i want the run to be start from yesterday 14:00
Say example,
04/04/2017 10:00 - Run from 04/03/2017 14:00 to 04/04/2017 10:00
04/04/2017 11:00 - Run from 04/03/2017 14:00 to 04/04/2017 11:00
04/04/2017 12:00 - Run from 04/03/2017 14:00 to 04/04/2017 12:00
04/04/2017 13:00 - Run from 04/03/2017 14:00 to 04/04/2017 13:00

Thanks in advance

Re: Adding running time in the query

richgalloway — Tue, 04 Apr 2017 12:38:57 GMT

Try earliest=-1d@d+14h

Re: Adding running time in the query

DalJeanis — Tue, 04 Apr 2017 18:07:44 GMT

And you'd probably be better off delaying the run for a few minutes to make sure all the indexing has been done for the hour you are just checking. For example, run at 10:10 for yesterday 14:00 through today 10:00.

earliest=-1d@d+14h latest=@h

Re: Adding running time in the query

Kwip — Wed, 05 Apr 2017 06:34:21 GMT

That works!!! Thank you!!

Re: Adding running time in the query

Kwip — Fri, 13 Oct 2017 05:47:26 GMT

Hello Daljeanis,
Sorry for the question on old post. I will create new question if you required.

earliest=-1d@d+14h latest=@h ==> this one will is working fine, if i am searching the yesterday's information on today. what if I need to search the same day.

I want to monitor my dashboard from today 7 Am to tomorrow 5 AM. I don't want to set the time manually.

FYI, My dashboard contains list of jobs running from 7AM to next day 5AM.

I need to monitor the progress continuously, so set up the auto refresh on every 5 minutes. Now I want to set the time in such a way that it will take the start time as 7AM today and end time is now or next day 5AM during every refresh.

Please take a look and let me know the possibilities. Thanks in advance!!!

Re: Adding running time in the query

Kwip — Fri, 13 Oct 2017 05:51:23 GMT

Created new question for this

"Setting the query start time and end time"