Combine AppID from Azure Logs with the Application Name – How to
If we query for AppID from Log Analytics, like: MicrosoftGraphActivityLogs | summarize NumberOfRequests=count() by AppId | order by NumberOfRequests desc we usually need to combine it with the Application name. So we need to export all Enterprise Applications and App Registrations to csv from: https://portal.azure.com/#view/Microsoft_AAD_IAM/StartboardApplicationsMenuBlade/~/AppAppsPreview/menuId~/null https://portal.azure.com/#view/Microsoft_AAD_IAM/ActiveDirectoryMenuBlade/~/RegisteredApps Do not forget about Managed Identities, you can do […]