Monitor identity activity with logs, workbooks and reports
Sign-in, audit and provisioning logs, diagnostic settings, KQL in Log Analytics, workbooks and Identity Secure Score.
- 18 min
- 5 concepts
- Try it yourself
- 5-question check
Learn
Entra ID records every sign-in and every change. The admin center keeps them for a limited time, so send them to Log Analytics to query them with KQL, build workbooks and alert on what matters.
- 1
Review and analyze sign-in, audit, and provisioning logs by using the Microsoft Entra admin center
Sign-in logs: interactive and non-interactive user sign-ins, service principal and managed identity sign-ins, with status, error code, location, device, Conditional Access results and risk. Audit logs: changes to users, groups, apps, roles and policies. Provisioning logs: users created, updated or failed by SCIM and sync. Entra keeps them 30 days with P1/P2 (7 days on Free).
Remember: Sign-ins: who got in. Audit: who changed what.
- 2
Configure diagnostic settings, including configuring destinations such as Log Analytics workspaces, storage accounts, and Azure Event Hubs
A diagnostic setting streams log categories (SignInLogs, NonInteractiveUserSignInLogs, ServicePrincipalSignInLogs, AuditLogs, ProvisioningLogs, RiskyUsers and more) to a Log Analytics workspace (query and alert), a storage account (cheap long-term archive) and/or an event hub (a third-party SIEM). Needs P1 or P2.
Remember: Query: Log Analytics. Archive: storage. Third-party SIEM: event hub.
- 3
Monitor Microsoft Entra ID by using KQL queries in Log Analytics
Sign-ins land in the
SigninLogstable and changes inAuditLogs.ResultType0 means success; other values are error codes, such as 50126 (bad password) and 53003 (blocked by Conditional Access). Try the queries in the playground.Remember: ResultType 0 = success.
- 4
Analyze Microsoft Entra ID by using workbooks and reporting
Built-in workbooks (backed by Log Analytics) include Conditional Access insights and reporting, Sign-ins using legacy authentication, Authentication prompts analysis and Sensitive operations report. Usage and insights reports cover authentication methods registration and usage, and application sign-in activity.
Remember: Find legacy auth before blocking it: the legacy authentication workbook.
- 5
Monitor and improve the security posture by using Identity Secure Score
Identity Secure Score is a percentage showing how well you follow Microsoft's identity recommendations, such as requiring MFA for admins, blocking legacy authentication and enabling self-service password reset. Each improvement action shows its score impact, and you can mark actions as resolved through third party or accepted risk.
Remember: Each improvement action shows its score impact.
From log to insight
- Entra IDGenerates sign-in, audit and provisioning logs.
- Diagnostic settingStreams chosen categories out.
- Log AnalyticsTables like SigninLogs and AuditLogs.
- KQL and workbooksQuery, visualise and alert.
Try it
Query sample sign-in logs. Pick an example or write your own.
This interactive part needs JavaScript.
In the portal
- Sign-in logsEntra admin center: Entra ID > Monitoring & health > Sign-in logs
- Diagnostic settingsEntra admin center: Entra ID > Monitoring & health > Diagnostic settings
- WorkbooksEntra admin center: Entra ID > Monitoring & health > Workbooks
- Identity Secure ScoreEntra admin center: Entra ID > Overview > Recommendations
Key terms
Click a card to see the definition.
Check your understanding
5 questions. Score 80% or more and these skills are marked as confident in your SC-300 study plan.
Where should logs go for a third-party SIEM?
Event hubs stream to external tools.
Which ResultType means a successful sign-in?
0 is success.
Which log records a user being added to a group?
Directory changes go to the audit log.
Which workbook helps find who still uses legacy authentication?
It lists legacy protocol sign-ins.
How long does Entra keep sign-in logs with P1?
Send them elsewhere for longer retention.
Sources
- Microsoft Learn: What are Microsoft Entra sign-in logs?
- Microsoft Learn: Configure Microsoft Entra diagnostic settings
- Microsoft Learn: Microsoft Entra data retention
- Microsoft Learn: Microsoft Entra workbooks
- Microsoft Learn: Identity Secure Score
Facts in this lesson are from Microsoft Learn. This site isn't affiliated with Microsoft.