Office 365 license assigned date export

Question

Office 365 license assigned date export

Deepak Raghav 1

Hi Team,

I've group based licensing environment, I am looking to export assigned license date for each subscription (Mainly Visio, Project).
I tried to go to Billing --> License --> Selected Product --> Export but License assignment or date is missing in the export. I also tried to export from Admin center report but there's no option when did Visio or Project license assigned.

Any help would be appreciated.

Marilee Turscak-MSFT 37,251 Microsoft Employee Moderator

You should be able to get the timestamps using Azure AD Powershell:

(Get-AzureADUser -SearchString emailuser).AssignedPlans

Example:

[23:03:55][Login script]# (Get-AzureADUser -SearchString HuKu).AssignedPlans

AssignedTimestamp   CapabilityStatus Service                       ServicePlanId
-----------------   ---------------- -------                       -------------
06/01/2018 07:44:03 Enabled          MicrosoftCommunicationsOnline 5a10155d-f5c1-411a-a8ec-e99aae125390
06/01/2018 07:44:03 Enabled          PowerBI                       70d33638-9c74-4d01-bfd3-562de28bd4ba

Reference: Related discussion here

There is a blog post here that also has an example of how to do this.

Let me know if this helps.

Your answer

Marilee Turscak-MSFT 37,251 Reputation points Microsoft Employee Moderator

2021-09-24T17:18:12.333+00:00

You should be able to get the timestamps using Azure AD Powershell:

(Get-AzureADUser -SearchString emailuser).AssignedPlans

Example:

[23:03:55][Login script]# (Get-AzureADUser -SearchString HuKu).AssignedPlans AssignedTimestamp CapabilityStatus Service ServicePlanId ----------------- ---------------- ------- ------------- 06/01/2018 07:44:03 Enabled MicrosoftCommunicationsOnline 5a10155d-f5c1-411a-a8ec-e99aae125390 06/01/2018 07:44:03 Enabled PowerBI 70d33638-9c74-4d01-bfd3-562de28bd4ba

Reference: Related discussion here

There is a blog post here that also has an example of how to do this.

Let me know if this helps.

Share via

Office 365 license assigned date export

Your answer