how to get the list of applications report(.csv file) assigned to user in azure using Powershell(Script)/Command.

test A 86 Reputation points
2023-03-30T14:04:14.8266667+00:00

Hi,

I need to download the report for the list of applications assigned to the user in Azure AD via PowerShell Script/Command . need help in this , thanks in advance.

Active Directory
Active Directory
A set of directory-based technologies included in Windows Server.
5,932 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,389 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,100 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,664 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. 2023-03-30T16:41:58.2066667+00:00

    Hello @test A , to get the list of applications a user is assigned you can user the Microsoft Graph PowerShell overview

    Connect-MgGraph -Scopes "User.ReadBasic.All"
    Get-MgUser -UserId <oid> -ExpandProperty appRoleAssignments|
    select -ExpandProperty appRoleAssignments|
    select -Property @{N="AppId"; E={$_.resourceId}}, @{N="AppDisplayName"; E={$_.resourceDisplayName}} -Unique|
    ConvertTo-Csv -NoTypeInformation
    

    Let us know if you need additional assistance. If the answer was helpful, please accept it and complete the quality survey so that others can find a solution.