Forum Discussion

TonyRedmond's avatar
Feb 07, 2024

Including Costs in a Microsoft 365 Licensing Report

This article describes how to include user license costs in a Microsoft 365 tenant licensing report created with the Microsoft Graph PowerShell SDK. The report includes annual costs for all licenses assigned to each user plus an overall licensing summary for the tenant. It even reports how effective the tenant is at assigning licenses!

 

https://practical365.com/report-user-license-costs/

 

  • Script Updated:

     

    Tracking Licensing Costs (by Department and Country) for Microsoft 365 Tenants

    The latest version of the Microsoft 365 Licensing Report script includes code to generate cost analyses for the departments and countries assigned to user accounts. Everything works well if the properties of Entra ID user accounts are complete and accurate. Sometimes this isn’t so, and that leads to problems when attributing costs at a department or country level.

     

    https://office365itpros.com/2024/02/14/microsoft-365-licensing-report/

     

    • TonyRedmond's avatar
      TonyRedmond
      MVP

      Adding Cost Center Reporting to the Microsoft 365 Licensing Report

       

      The Microsoft 365 licensing report now supports a cost center analysis based on cost center values stored in an Exchange custom attribute. The new analysis is entirely optional, but it seems like many tenants store cost center values in custom attributes, so this update might work well for them. That is, if the cost center data stored in Exchange is accurate… Rubbish in always means rubbish out…

       

      https://office365itpros.com/2024/07/23/microsoft-365-licensing-report-192/

       

      • TonyRedmond's avatar
        TonyRedmond
        MVP
        Microsoft 365 Licensing Report Script V1.94

        The Microsoft 365 Licensing Report PowerShell script has been upgraded to generate detailed license information and to deal with expired license subscriptions. You can download V1.94 of the script from GitHub. Before attempting to run the licensing report script, take the time to read previous articles to understand the basics of the script and how to generate the files used for pricing information.

        https://office365itpros.com/2024/09/12/microsoft-365-licensing-report-194/

Resources