'Retrieve AzureAD Users sign-in logs Kusto Resource Graph Query

I am trying to get a list of users logged into azure AD, that can be seen under Users | All Users from the azure portal, using Kusto Resource Graph Query but does anybody know how to call this? i understand i can List all sign-ins via http response

GET https://graph.microsoft.com/v1.0/auditLogs/signIns

but how do i call this in Resource Graph?

I know i can call resources to Show a List resources sorted by name

e.g

Resources
| project name, type, location
| order by name asc

and can call

resources
| where identity contains "userAssignedIdentities"

but all im returning is user assigned identities.. and not Users i.e User Type, User Principle Name, Name, Account Enabled, Company etc

that should be specific to All Users and Signin-Logs

any help would be appreciated

many thanks

azureazure-active-directoryazure-data-explorerazure-resource-graph


Solution 1:[1]

Yep this works bud, also changing my permission to security admin.. many thanks

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 user203818

Related Questions