Hi, when running this KQL query,
ServiceHealthResources
| where type =~ 'Microsoft.ResourceHealth/events' and properties.Status == 'Active'
| extend EventType = properties.EventType, EventLevel = properties.EventLevel, RecommendedActions = properties.RecommendedActions, PlatformInitiated = properties.PlatformInitiated, SubscriptionId = properties.SubscriptionId, LastUpdateTime = properties.LastUpdateTime, EventSubType = properties.EventSubType, EventSource = properties.EventSource, impactType = properties.impactType, BillingId = properties.BillingId, duration = properties.duration, Status = properties.Status, Title = properties.Title, ImpactedService = properties.Impact.ImpactedService, ImpactedRegions = properties.Impact.ImpactedRegions.ImpactedRegion, TrackingId = properties.TrackingId, Summary = properties.Summary, Priority = properties.Priority, ImpactStartTime = properties.ImpactStartTime, ImpactMitigationTime = properties.ImpactMitigationTime | project EventType, EventLevel, RecommendedActions, PlatformInitiated, SubscriptionId, LastUpdateTime, EventSubType, EventSource, impactType, BillingId, duration, Status, Title, ImpactedService, ImpactedRegions, TrackingId, Summary, Priority, ImpactStartTime, ImpactMitigationTime
The date/time columns are returned in this raw format e.g. 638961219785560600
How can I convert this to a human-readable date/time, so it can be filtered, etc?