View Access Packages assigned to a list of users supplied via a CSV file.

Question

Hello, Is there a way to use graph (or any other command line utility) to view the Azure Access Packages assigned to a list of users that is provided by a CSV file?

something like:

$users = import-csv c:\files\userlist.csv

Get-MgEntitlementManagementAssignment $users |export-csv c:\files\UserswithAccessPackages.csv

Answer 1

Sure, you should be able to use something like this:

Connect-MgGraph -Scopes EntitlementManagement.Read.All

Import-Csv c:\files\userlist.csv | % { Get-MgBetaEntitlementManagementAccessPackageAssignment -Filter "target/objectid eq $($_.ID)" }

where the c:\files\userlist.csv CSV file should contain a column ID with the GUID of the user. If you want to use a property such as the UPN, you will have to resolve the value first to a GUID, as the resource does not support filtering by UPN.