Forum Discussion
SB V
Sep 07, 2022Brass Contributor
Questions on Microsoft Sentinel
Hi Community, Our customer raised the below queries relates to Fusion rules in Microsoft Sentinel. (1) For alerts/incidents triggered by fusion rules, if it’s false positive then any input fr...
- Sep 08, 20221. no answer
2. You could, if you edit the KQL, convert UTC to local: https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/datetime-utc-to-local-function UTC is used throughout Sentinel.
Clive_Watson
Sep 08, 2022Bronze Contributor
1. no answer
2. You could, if you edit the KQL, convert UTC to local: https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/datetime-utc-to-local-function UTC is used throughout Sentinel.
2. You could, if you edit the KQL, convert UTC to local: https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/datetime-utc-to-local-function UTC is used throughout Sentinel.
SB V
Sep 08, 2022Brass Contributor
Hi Clive, One question, is there a way to rename the field so it doesn’t auto append ‘UTC’ to the field name?
- Clive_WatsonSep 09, 2022Bronze Contributor
Yes, but it requires changing the format from a datetime to a string (see last line of this example).
let localTime = 'US/Pacific';
Heartbeat
| extend newTime = datetime_utc_to_local(TimeGenerated, localTime)
| summarize count() by Computer, newTime, TimeGenerated
| project Computer, TimeGenerated, localTime = tostring(newTime)- SB VSep 09, 2022Brass ContributorHi Clive, Thank you very much for the answer.