See Licensed vs Available Microsoft 365 Seats for Every Customer From Inside Syncro
TL;DR
- A PowerShell script can document Microsoft 365 license usage per tenant directly in Syncro, covering every licensed and unlicensed user across all customers.
- The report shows available versus consumed seats per tenant, so over-purchased and over-assigned licensing surfaces without logging into each admin center.
- Running it on a schedule keeps the license picture current in the PSA, where it sits next to the customer record instead of in a spreadsheet.
- The script is open and published on GitHub for MSPs to adapt to their own Syncro environment.
Unassigned Microsoft 365 seats are quiet money. A customer churns three staff, the licenses stay billed, and nobody notices until the next true-up because checking means logging into each tenant's admin center one at a time. Across a book of business, that manual sweep never happens often enough to catch the drift. Automating it puts the answer where you already work.
This script documents Microsoft 365 license information across all of your customers in Syncro. It displays every current licensed and unlicensed user, and it shows what licenses are available versus consumed on a per-tenant basis. Instead of a spreadsheet you update by hand, the report lands against the customer record in Syncro and stays current on whatever schedule you run it.
Get the script
The script is published openly so you can adapt it to your own Syncro environment: the Syncro-Documentation repository on GitHub (opens in new tab).
Watch it in action
We walk through running the license report and reviewing the output in Syncro in this video: watch the Syncro license report tutorial on YouTube (opens in new tab).
This license report is one piece of a larger Syncro documentation set that also covers MFA status, Exchange, and Intune. We cover the full suite in our walkthrough of automating Microsoft 365 documentation in Syncro.
Frequently asked questions
What does the Microsoft license report show per customer?
All current licensed and unlicensed users, plus a per-tenant view of which licenses are available versus consumed. That makes both unassigned seats you are paying for and users missing a license visible in one place.
Where does the documentation end up?
In Syncro, tied to the customer record, so the license picture lives alongside the rest of your documentation for that client rather than in a separate report.
License counts are easy to see. Misconfigurations are not.
This report tells you who is licensed. It will not tell you whether the security those licenses pay for is actually turned on. CloudCapsule checks 250+ Microsoft 365 controls per tenant in about 60 seconds.
See the features
Written by
Nick Ross
CEO · Microsoft MVP · Founder, T-Minus 365
Nick is not just a CEO, he's a respected thought leader and influencer in the MSP space. Tens of thousands of MSPs learn through his YouTube channel, T-Minus365. Nick has been honored as a three-time Microsoft MVP for his educational content; his expertise and influence are the backbone of our mission, ensuring that you are in the best hands when it comes to security.
Nick joined Pax8 in 2017, where he would ultimately oversee product management for PSA and Microsoft integrations. Following his tenure at Pax8, Nick has continued to demonstrate his leadership prowess as an executive at various MSPs, culminating in his most recent role at Sourcepass.
Nick holds a Bachelor's Degree in Business Management from Florida State University, as well as a Minor Degree in Entrepreneurship. In his free time, Nick is an avid hiker, reader, and fitness-junkie.
