KQL time range from 09:00:00 to 18:00:00 pm

Question

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... because some Metrics shows % of efficiency but... I just want to see the "efficiency" in labor hours.

clive_watson · Answer

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

miguelparada · Answer

Jahirt_Ruiz_Vista&nbsp;have you considered to user the kusto operator "between"?&nbsp;https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/betweenoperator

Forum Discussion

KQL time range from 09:00:00 to 18:00:00 pm

2 Replies

Resources