That's correct. Entra ID Premium P2 is required to query risky users and utilize advanced security features, including Identity Protection, which identifies and reports risky users. This premium tier provides the capabilities necessary to detect and respond to identity-based threats within your organization.
With Entra ID Premium P2, you can access advanced features like:
- Risky Users Detection: Identifying and flagging users with suspicious activities or compromised credentials.
- Kusto Query Language (KQL): Running custom queries against the identity protection logs to retrieve detailed information about risky users.
- Automated Responses: Setting up alerts and automated workflows, such as sending email alerts to the relevant team when risky user activity is detected.
Details at https://www.microsoft.com/en-us/security/business/microsoft-entra-pricing
If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.
hth
Marcin