Mar 29 2020
11:06 AM
- last edited on
Apr 08 2022
10:21 AM
by
TechCommunityAP
Mar 29 2020
11:06 AM
- last edited on
Apr 08 2022
10:21 AM
by
TechCommunityAP
Dears,
I would like to have a query to export the first signin for each user per day.
i.e. i would like to know the first time this user signedin each day.
thank you for your support
Mar 29 2020 03:36 PM
SigninLogs
| where TimeGenerated > startofday(ago(0d))
| summarize Count = count() , arg_min(TimeGenerated, *) by UserDisplayName
| order by Count desc, UserDisplayName asc
arg_min, will finds the first occurrence for you.
Mar 29 2020 11:00 PM
Working :), thank you dear. Appreciated.