Query specific day time range

Hello there

I would like to ask whether there is a way to create query with filter for specific day time range ?
Use case
Show asset authentication or file access out of working hours.
Like admin is connection to system between 9:00pm and 6:00am.



Hello Peter,

You could use a query such as this below to find all authentication attempts outside certain hours of the day:


This may need some tuning to fit your specific use case but I believe it’s a good starting point. Let me know if you have any trouble with it.


Great. Tony, thank you very much. We will try.