Joe Stocker (@itguysocal) 's Twitter Profile
Joe Stocker

@itguysocal

Christian Family Man, CEO of Patriot Consulting (Microsoft Security Partner) Author of "Securing Microsoft 365" Microsoft MVP (Security) (2020-present)

ID: 468750795

linkhttp://www.TheCloudTechnologist.com calendar_today19-01-2012 21:40:07

6,6K Tweet

6,6K Takipçi

1,1K Takip Edilen

Joe Stocker (@itguysocal) 's Twitter Profile Photo
Joe Stocker
@itguysocal

14 days ago

KQL to spot missing Microsoft logs (excludes weekends since those are normally low) SigninLogs | where TimeGenerated >= ago(90d) | summarize SignInCount = count() by bin(datetime_utc_to_local(TimeGenerated,"US/Pacific"), 1d) | where dayofweek(Column1) !="6.00:00:00" and

KQL to spot missing Microsoft logs (excludes weekends since those are normally low) SigninLogs | where TimeGenerated >= ago(90d) | summarize SignInCount = count() by bin(datetime_utc_to_local(TimeGenerated,"US/Pacific"), 1d) | where dayofweek(Column1) !="6.00:00:00" and