Is there a way to get license assigned date to user from GRAPH REST API

Hritik Raushan 20

I am writing a powershell script to fetch the details of user who has been assigned a particular license.

Eg I want to fetch the details of all user who has been assigned POWER BI PRO license and the date on which license is assigned.

Hritik Raushan 20 Reputation points

2025-01-31T21:26:00.8333333+00:00
$users = Get-MgUser -All

$licensedUser = @()

foreach ($user in $users){

$hasLiscense = $false $userLicenses = Get-MgUserLicenseDetail -UserId $user.Id foreach ($license in $userLicenses) { if($license.SkuId -eq "skuid") { $hasLiscense = $true break; } } if($hasLiscense) { $licensedUser += $user }

} This code is giving me the output of all the user who has powerbi pro license but am not able to produce the date on which it was assigned.

1 answer

Vasil Michev 112.7K Reputation points MVP

2025-02-01T14:13:40.8333333+00:00

You cannot get the license assignment data directly, as there is no property that reflects that. You can take a look at the licenseAssignmentStates property, which does include the lastUpdatedDateTime, but that's on the individual service level, not the license as a whole. If you want the actual license assignment data, you will need to query the Entra audit log or the Unified Audit log for the corresponding licensing operations.

If you want more details on this, I'd recommend going over Tony's post here: https://practical365.com/azure-ad-license-assignment-dates/

He also provides a script sample to fetch the license assignment date via the audit log, you can find it here: https://office365itpros.com/2022/10/14/azure-ad-license-assignment-report/
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer