Microsoft Licence Audit Advisory

Auditing Your Microsoft Licence Usage — A Step-by-Step Guide to Find Savings

Most enterprises significantly overspend on Microsoft licensing. Internal audits routinely reveal 15–30% of licences are shelfware — paid for but unused. This guide provides a structured, repeatable six-step framework for systematically auditing your M365, Azure, and on-premises estate to uncover hidden savings before your next renewal or true-up.

By Redress ComplianceFebruary 202618 min read
15–30%
Typical Enterprise Shelfware Rate
6
Structured Audit Steps
60 Days
Inactivity Reclamation Threshold
30–40%
Per-User Savings E5 to E3
Microsoft Knowledge Hub MS Audit & Compliance Auditing Your Microsoft Licence Usage
📘

Part of the Microsoft Audits and Licence Compliance CIO’s Playbook

See also our Microsoft Knowledge Hub, Microsoft Optimisation Services, and EA Optimisation Service.

01

Why a Microsoft Licence Audit Matters

Waste quietly drains budgets by hundreds of thousands over a single contract term, compounding through automatic true-ups and renewal baselines nobody questions. Microsoft will happily sell you the latest premium E5 bundles, but it is your responsibility to ensure you are not overbuying.

An internal audit puts you back in control. By systematically examining your M365, Azure, and on-premises usage, you uncover hidden waste and create the data foundation you need for negotiation. This proactive approach identifies licences not delivering value so you can trim excess before your next annual true-up or renewal — entering negotiations armed with facts, not guesswork.

📊

Data Gathering

Export licence assignment and usage reports from M365 Admin Centre, Azure Cost Management, and on-premises tools.

🔍

Inactive Identification

Pinpoint departed employees, test accounts, shared mailboxes, and over-licensed users consuming premium licences.

📈

Utilisation Analysis

Examine per-service feature adoption. Find users on premium tiers who use only basic capabilities.

🔄

Continuous Governance

Build quarterly review cadences, automated inactivity flags, and IT governance integration.

Audit Scope

A comprehensive internal audit should span your entire Microsoft estate. Limiting scope to M365 alone misses significant waste in Azure, on-premises deployments, and add-on products.

What to Examine

  • M365 / Office 365: All user accounts, assigned licences, per-service usage for Exchange, Teams, OneDrive, SharePoint, and Copilot
  • Azure: Subscription inventory, resource utilisation, reserved instance coverage, idle and orphaned resources
  • On-Premises: Server licences (Windows Server, SQL Server, System Center), CALs, desktop deployments (Office LTSC, Project, Visio)
  • Hybrid Configurations: Licence Mobility, Azure Hybrid Benefit usage, dual-licensing obligations
  • Add-On Products: Power Platform (Power BI, Power Automate, Power Apps), Dynamics 365 modules, Defender suite, Copilot licences

Data Sources

SourceWhat It ProvidesAccess Path
M365 Admin CentreLicence assignments, per-user service usage, 60–90 day activity reports, inactive accountsAdmin portal → Reports → Usage
Azure Cost ManagementResource consumption, idle VMs, orphaned storage, reserved instance utilisationAzure Portal → Cost Management + Billing
Entra ID (Azure AD)Sign-in activity, last login dates, guest and external accountsEntra Admin Centre → Sign-in logs
SCCM / IntuneOn-premises software deployments, device inventory, installed product versionsConfiguration Manager reports / Intune portal
EA Agreement SummaryContracted entitlements, SKU details, pricing tiers, true-up historyVLSC or Microsoft Business Centre
02

Step 1: Gather Your Data

The foundation of any effective audit is comprehensive, accurate data. Incomplete data leads to missed savings and false confidence. Budget two to five days for this step depending on organisation size and data accessibility.

01
Export M365 Licence Usage Reports

Pull reports showing every user account and assigned SKU, plus 60–90 day usage summaries for Exchange, Teams, OneDrive, SharePoint, and premium workloads. This reveals the gap between what you are paying for and what people are actually consuming.

02
Retrieve Azure Consumption Data

Identify idle VMs, orphaned disks, underutilised reserved instances, and dev-test resources deployed in production pricing tiers. Azure waste typically runs 20–30% without active FinOps governance.

03
Inventory On-Premises Deployments

Use SCCM, Intune, or a SAM tool to map installed software against your EA entitlements. This comparison identifies pure shelfware, over-deployment, and legacy versions consuming licences unnecessarily.

04
Cross-Reference Entitlements Against Need

Overlay your EA schedule against usage data. Build a comparison of licences purchased vs assigned vs actively used. The gaps between these three numbers represent your savings opportunity.

03

Step 2: Identify Inactive Accounts

Inactive accounts are the lowest-hanging fruit in any Microsoft audit. Every licence assigned to a departed employee, forgotten test account, or over-licensed user is money wasted with zero business value delivered.

100%
Departed / Inactive Employees

Users who have left the organisation or have not logged in for 60+ days. Cross-reference Entra ID sign-in data against HR records. With annual turnover of 10–15%, this can account for hundreds of unused licences.

100%
Test / Shared / Service Accounts

Service accounts, test users, training environments, and shared mailboxes assigned full licences. Convertible to free shared mailboxes or Exchange Online Kiosk at no cost.

30–40%
Over-Licensed Users

Active users on premium tiers using only basic capabilities. E5 costs roughly 2.5× more than E3. Even 10% over-licensed in a 5,000-user org equals $200K+ annual savings.

Common Savings Scenarios

ScenarioExampleSavings
Departed employeesStill assigned M365 E5 three months after leaving100% licence cost
Test / training accounts20 test accounts with full E3 from a pilot project100% licence cost
Shared mailbox with full licenceReception desk on E3 instead of free shared mailbox100% licence cost
Over-licensed E5 → E3Finance analyst using only Outlook and Excel on E5~30–40% per user
Over-licensed E3 → F3Frontline worker with E3 using only Teams on mobile~75% per user

💼 Case Example: Global Logistics Firm — 1,400 Ghost Licences

Situation: A European logistics company with 8,000 employees engaged Redress Compliance for a pre-renewal audit. No internal usage review had been conducted over the previous two years.

Findings: 620 licences assigned to departed employees. 340 test and shared accounts with full E3 licences. 440 users on E5 using only email and Teams — E1-level functionality.

Result: Eliminating 960 unnecessary licences and downgrading 440 E5 → E3 reduced annual spend by $1.1M — a 22% reduction achieved entirely through internal clean-up before renewal negotiations even began.

Takeaway: The most impactful savings come from the simplest actions — removing licences that should never have been there and right-sizing users to the tier they actually need.

04

Step 3: Analyse Utilisation

Beyond inactive accounts, the next layer of savings comes from understanding what active users actually do with their licences. Many organisations assign E5 by default when E3 or even F3 would serve the same business need.

01
Map Feature Adoption by Licence Tier

Examine E5 users for premium workload adoption: Teams Phone, Power BI Pro, Defender for Office 365, eDiscovery, and Information Protection. Build a matrix of user → current tier → services actually used → recommended tier.

02
Audit Add-On Product Adoption

Examine Visio, Project, Power Automate, Power Apps, Copilot, and Defender licences. These are frequently purchased in bulk, but actual adoption is often below 20%. If you purchased 100 Visio licences but only 12 are actively used, 88 are reclaimable.

03
Assess Azure Service Utilisation

Examine VM CPU and memory right-sizing, storage access patterns, reserved instance coverage versus on-demand, and dev-test workloads running on production pricing. Azure waste typically runs 20–30% without active FinOps.

05

Step 4: Compile Your Optimisation Plan

Transform your audit findings into a structured action plan with clear financial impact. This document becomes your negotiation baseline — the foundation for every conversation with Microsoft at renewal.

Reclaim Unused

Per-licence cost × reclaimed licences = annual saving. Departed, test, shared mailboxes — all recoverable at 100%.

Downgrade Over-Licensed

Cost differential (E5 minus E3) × downgrades = annual saving. Focus on basic-feature-only users.

Eliminate Add-On Shelfware

Reduce Visio, Project, Power Platform, Copilot to match usage. Excess × per-licence cost = annual saving.

Right-Size Azure

Resize VMs, delete orphaned disks, convert on-demand to reserved. Monthly savings × 12 = annual saving.

Typical Findings by Category

CategoryTypical FindingEst. Annual Savings
Departed employee licences5–10% of total users still licensed$150–400K (5,000-user org)
Test / shared accounts50–200 accounts with unnecessary full licences$30–120K
E5 → E3 downgrades10–25% of E5 users need only E3$100–500K
Add-on shelfware60–80% of Visio, Project, Power Platform unused$50–200K
Azure waste20–30% of spend on idle or over-provisioned resources$80–300K

Never negotiate discounts before cleaning up your licence estate. Optimising your baseline first ensures that any percentage discount Microsoft offers is applied to the correct, lower number — not an inflated baseline that includes hundreds of licences nobody uses.

06

Step 5: Execute the Clean-Up

With your optimisation plan documented, execute the changes systematically. The goal is to reduce your licence baseline before the next true-up or renewal — every licence reclaimed or downgraded directly reduces what you pay.

01
Remove and Revoke Unneeded Licences

Immediately unassign licences from departed employees, test accounts, and shared mailboxes. Process in batches with a documented change log. This directly reduces your renewal baseline and true-up count.

02
Execute Tier Downgrades

Move E5 users to E3, and E3 users to F3 where analysis supports it. Communicate changes to affected users and managers in advance, explaining which features are removed and confirming no business-critical functionality is lost. A well-communicated downgrade generates zero complaints.

03
Validate with Stakeholders

Verify with the relevant manager or system owner before revoking any licence. Occasionally an inactive account is a service account or a user on extended leave. Spending 10 minutes verifying avoids the reputational cost of disrupting a critical workflow.

🏥 Case Example: Healthcare Network — $740K Saved Before Renewal

Situation: A US healthcare network with 12,000 employees was 90 days from their EA renewal. Microsoft’s renewal proposal offered 12,000 M365 E5 licences at a 10% discount — $5.4M annually. They engaged Redress for a rapid audit.

Findings: 800 licences assigned to departed staff. 1,600 clinical staff on E5 using only Teams and Outlook on shared workstations — F3 candidates. 200 Visio licences with only 25 active users.

Result: Removing 800 ghost licences, downgrading 1,600 to F3, and reducing Visio to 30 dropped the renewal baseline from $5.4M to $4.1M — $740K annual saving. Microsoft’s 10% discount on the inflated baseline would have saved only $540K. The internal audit delivered 37% more savings than Microsoft’s own discount offer.

Takeaway: Optimise your baseline first. Then negotiate the discount. The order matters — a percentage discount applied to a clean, right-sized baseline delivers far more value than the same discount applied to an inflated number.

07

Step 6: Build a Continuous Process

A single audit captures a point-in-time snapshot. Without ongoing governance, shelfware accumulates again within months as employees join, leave, and change roles. The organisations that maintain 90%+ licence utilisation treat audit as a continuous process, not a one-off exercise.

01
Establish Quarterly Review Cadence

Schedule internal usage reviews every quarter, assigned to IT asset management or FinOps. Each review takes two to three days using the methodology established in Steps 1–5. Track findings and savings cumulatively.

02
Automate Inactivity Detection

Define clear criteria: 60 days without sign-in triggers review; 90 days triggers automatic removal with a seven-day grace period. Use PowerShell scripts or SAM tools to automate flagging and notification.

03
Integrate with HR and IT Governance

Connect licence provisioning and deprovisioning to onboarding and offboarding workflows. Flag licence reclamation within 48 hours of an employee departure. Require new projects to submit licence requests with business justification.

04
Report to Finance and Procurement

Produce a quarterly optimisation report including current utilisation rates, licences reclaimed, cost avoidance, and projected savings. This creates accountability and ensures visibility at leadership level.

✅ Audit Readiness Checklist

  • M365 usage reports exported — licence assignments and 60–90 day activity data from Admin Centre
  • Azure consumption data retrieved — resource utilisation, idle VMs, orphaned storage from Cost Management
  • On-premises inventory complete — SCCM or Intune data mapped against EA entitlements
  • Inactive accounts identified — departed employees, test accounts, shared mailboxes with full licences
  • Over-licensed users mapped — E5 users consuming only basic features flagged for E3 or F3 downgrade
  • Add-on adoption audited — Visio, Project, Power Platform, Copilot counts compared to active usage
  • Optimisation plan with savings calculated — total annual savings quantified across all categories
  • Clean-up executed before true-up or renewal — unnecessary licences removed, tiers adjusted
  • Stakeholder sign-off obtained — managers confirmed no critical functionality impacted
  • Quarterly review cadence established — automated inactivity detection and HR integration in place

Frequently Asked Questions

How long does a Microsoft licence audit take?+
For a mid-sized organisation with 2,000–10,000 users, expect two to four weeks from data gathering through action plan delivery. The bulk of the time is in Steps 1 and 2 — gathering data and identifying inactive accounts. Subsequent quarterly reviews take just two to three days, working from the established baseline and methodology.
Can we audit without third-party SAM tools?+
Yes. Microsoft’s native portals — M365 Admin Centre, Entra ID, and Azure Cost Management — provide sufficient data for a thorough audit. SAM tools add value for on-premises discovery, automated licence reconciliation, and historical trending, but they are not prerequisites. Start with native data and consider SAM tools if you need deeper automation.
Should we audit before or after receiving Microsoft’s renewal proposal?+
Before — ideally six to nine months before your EA renewal. Auditing before means you enter negotiations with clean data and a reduced baseline. Auditing after compares your findings against an inflated starting point, where any discounts Microsoft offers are applied to numbers that include shelfware. The sequence matters: optimise first, then negotiate.
What if we accidentally remove a licence someone needs?+
Step 5 includes stakeholder validation for exactly this reason. Always verify with the relevant manager before revoking. M365 licences can be reassigned within minutes if an error is made, and no data is lost. Best practice is to build a seven-day grace period: flag the licence for removal, notify the manager, and execute only after confirmation or seven days with no objection.
How do we prevent shelfware from accumulating again?+
Step 6 addresses this directly. The three most effective controls are: automated inactivity detection using PowerShell or SAM tools to flag accounts with 60+ days of no sign-in activity; integration with HR workflows for automatic licence reclamation when an employee departs; and quarterly governance reviews with Finance reporting. Organisations implementing all three consistently maintain 90%+ utilisation versus 70–75% without continuous governance.

📚 Microsoft Audits and Licence Compliance — Article Series

Related Resources

FF

Fredrik Filipsson

Co-Founder, Redress Compliance

Fredrik Filipsson brings over 20 years of enterprise software licensing expertise, having worked directly for IBM, SAP, and Oracle before co-founding Redress Compliance. With experience advising hundreds of organisations on Microsoft licensing audits, estate optimisation, and renewal negotiations, Fredrik leads the firm's multi-vendor advisory practice from offices in Fort Lauderdale, Dublin, and Dubai.

← Back to Microsoft Knowledge Hub
Always-On Advisory

🛡️ Vendor Shield — Subscription Advisory

Continuous, always-on advisory coverage across Oracle, Microsoft, SAP, Salesforce, IBM, and more. One subscription. Every vendor. Always prepared, never outmanoeuvred.

Learn About Vendor Shield Multi-vendor protection
Licensing Intelligence

Stay Ahead of Vendor Moves

Monthly licensing intelligence, audit alerts, and negotiation tactics from our advisory team. Trusted by 1,000+ enterprise leaders.

Subscribe Free No spam. Unsubscribe anytime.