How to Find the Time Stamp for the License Assigned in M365/O365 for an End User or for the Entire Tenant

 

Below is the Step by Step Instruction for getting the Time Stamp for the End User License Assignment for any user. The commands can be used to get the output for all the Licenses we only need to change the License SKU in the Script and we should be able to get output.


1. First Step is to Install the Azure AD Module.

•         Open the Powershell

•         Run the Command Install-Module -Name AzureAD

•         If Prompted Press Yes and Install the Module

 

2. Next Step is to Connect to Office 365 Admin Portal via PowerShell

•         In case the MS Online Powershell is missing we need to install the same. To install the MS Online Powershell Open the Powershell in the Admin Mode and run the following Command

•         Install-Module MSOnline

•         To Connect to the MSOnline we need to run the next Command

•         Import-Module msonline

•         Connect-MsolService -Credential $cred

 

When prompted please enter the Office 365 Admin Password for the Connecting.

 

3. Now we need to identify the SKU for which we need to get the TimeStamp.

•         After we are connected to the Microsoft Online Portal via Powershell we need to run the following command

•         Get-MsolAccountSku

 

Output will be as follows: -

 AccountSkuId                                                    ActiveUnits WarningUnits ConsumedUnits

------------                                                            -----------         ------------         -------------

reseller-account:STREAM                                  1000000               0                         0

reseller-account:ENTERPRISEPREMIUM                 25                    0                        25

reseller-account:WINDOWS_STORE                         0                  0                       0

reseller-account:PHONESYSTEM_VIRTUALUSER    24                0                        4

reseller-account:TEAMS_COMMERCIAL_TRIAL  500000           0                        2

 

4. Now for whichever License we want to get the Time Stamp for the Entire Tenant we need to run the following Script. In the Script we need to modify the SKU separately and also the Location where you want to save the file.

 

 

$CurrentDate = Get-Date

$CurrentDate = $CurrentDate.ToString('dd-MM-yyyy_hh-mm')

$sku = "ENTERPRISEPREMIUM"

 

$cred = Get-Credential

Connect-AzureAD -Credential $cred

 

$e3 = Get-AzureADSubscribedSku | ? {$_.SkuPartNumber -like "*$sku*"} | select -expand SkuPartnumber

$planE3 = Get-AzureADSubscribedSku | ? {$_.SkuPartNumber -like "*$sku*"} | select -expand Serviceplans | select -expand ServicePlanId

 

$users = Get-AzureADUser -All:$True

$count = $users.count

 

$report = @()

 

$i = 0

foreach ($u in $users)

{

    $i++; Write-Host "$i of $count"

 

    $upn = $u.UserPrincipalName

    $comp= $u.CompanyName

    $state= $u.State

 

    $plans = $u | select -expand AssignedPlans

 

    $plans1 = foreach ($p in $planE3){ $plans | ? {$_.ServicePlanId -like "*$p*"} }

 

    if ($?)

    {

        foreach ($plan in $plans1)

        {

            $when = $plan | select -expand AssignedTimeStamp

            $service = $plan.Service

            $servicePlanId = $plan.ServicePlanId

 

           

            $report += New-Object psobject -Property @{UserPrincipalName = $upn; AssignedTimestamp = $when; `

                    Service = $service; CompanyName = $comp; State = $state; SkuPartnumber = $e3; ServicePlanId = $servicePlanId}

           

        }

    }

}

 

$report | select UserPrincipalName,CompanyName,State,AssignedTimestamp,SkuPartnumber,Service | Export-CSV C:\licences_$CurrentDate.csv –noType -Encoding:UTF8 -Delimiter ";"

 

5. In case we want to get the Time Stamp for the Individual User we need to run the following commands

 

•         Connect-AzureAD

•         (Get-AzureADUser -SearchString userid@domain.com).AssignedPlans

 

 

Note: -

1.    Kindly change the path of the File in case we are running the output for all the users in the Tenant according to the destination required.

2.    In the All User Script please change the SKU of the License which is assigned to the user otherwise the output will be a Blank File.

Comments

Post a Comment

Popular posts from this blog

Multiple Instances Microsoft Teams Application

Microsoft Teams Application has always been improving based on the feature’s availability in the Teams Application. Microsoft has been enhancing the features some based on the existing Skype for Business Application and some based on the User Voice Request. There is already an ongoing User Voice Request to have multiple instances of Microsoft Teams on the Windows Machine. The major use of the multiple instances of Microsoft Teams Application: - 1.       Being from the Support industry the people need to be logged into the corporate account and a test account for testing the features simultaneously 2.       To do multitasking project with multiple people viewing the desktop from two different people. 3.    Attending Two Different Meeting at a same time wherein one of the meeting you are a silent participant or just the host of the meeting Disadvantages of using multiple instances of Microsoft Teams Applic...
Read more

Delegate Features in Microsoft Teams Get a Major Overhaul, Including Call Barging

Image
Microsoft Teams has added new features for Delegate. One of the key features added recently is Call Barge. Is this the start of the Contact Centre Development within Microsoft? Let’s see what the major changes are introduce to the Microsoft Teams Voice Delegate.        1.   Firstly, Microsoft introduce a separate Call Logs for the Delegates and Delegator. All the Person Calls              will be in a separate Call History and Delegate Call History will be separate.  Delegate’s Personal Call History Delegator’s Call History 2.      In case the users are using New Teams Client the Delegation Feature is in Call Tabs. It is still under the General Tab in the Old Teams Client 3.      Earlier we only had three configurations while Delegating the Access. Now we have Five configuration which includes the configuration f...
Read more

Microsoft Audio Conferencing for Microsoft Teams

Microsoft Office 365 Administrator Always find it difficult to justify the Audio-Conferencing Billing for the Microsoft Audio Conferencing Services. The Audio-Conferencing services has been running since Skype for Business Online and now the same is be rolled into as an Integration into Microsoft Teams as well. What is Microsoft Teams Audio Conferencing Services? All the users can join the Microsoft Teams Meeting using different Microsoft Teams Client on the Desktop Client, Mobile Client, Web Client on all the different platforms. What if the user trying to connect to the meeting has a bad internet connectivity? Or do not have Teams Client on the device which they are using. Hence Microsoft has now offered Microsoft Teams Audio Conferencing Services wherein the users can join the Microsoft Teams Meeting using the PSTN Conferencing Services and participate in the Microsoft Teams Meeting using the PSTN Audio   Who can purchase the Microsoft Audio Conferencing Servi...
Read more