Forum Discussion
Jahirt_Ruiz_Vista
May 20, 2022Copper Contributor
KQL time range from 09:00:00 to 18:00:00 pm
I am trying to create a query that will only bring me the results from the working day from 9 am to 18 pm.... how can I create it? I do not found any information about this kind of time range... ...
MiguelParada
May 21, 2022Copper Contributor
Jahirt_Ruiz_Vista have you considered to user the kusto operator "between"? https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/betweenoperator
Clive_Watson
May 22, 2022Bronze Contributor
https://techcommunity.microsoft.com/t5/microsoft-sentinel-blog/how-to-align-your-analytics-with-time-windows-in-azure-sentinel/ba-p/1667574 please see my example 9