Harbour ITMenu

Powered by Office Sentry 2.3.1

You're in the demo. Three fictional clients with made-up people. Look around freely: nothing can be changed, and it all resets every night.Get Office Sentry
Clients/Northwind Traders

Northwind Traders

northwindtraders.onmicrosoft.com
Monthly review

Licences and subscriptions

Every subscription with licences bought, assigned and available, its cost and renewal date, trials and lapsing subscriptions, and who has which licence, directly or by group.

All clients
Download PDFXLSX
Monthly cost
£623.30
Licences bought, at your prices
Licences in use
36 of 41
Paid licences assigned
Lapsing within 30 days
0
Trials in use, expired or suspended
Trials
0
Active trial subscriptions
Licence errors
0
Licences that couldn't be assigned
Assigned by group
2 of 36
Licences that come from a group
Subscriptions 3Renewals and expiry 2Who has which licence 36Assignment problems 2Groups that assign licences 1

Subscriptions 3

CSV

Every product the tenant has, with licences bought, assigned and still available, and what they cost a month at your prices. Free products are listed last.

By licenceAssignedAvailable
  1. Microsoft 365 Business Premium32
  2. Microsoft 365 Business Basic9
  3. Visio Plan 20
LicenceStatusPurchasedAssignedAvailableSuspendedCost / monthNext renewal or endTrial
Visio Plan 2 lowSuspended0000Not priced1 Nov 2026Yes
Microsoft 365 Business BasicActive9720£44.10No
Microsoft 365 Business PremiumActive322930£579.2011 Mar 2027No

Renewals and expiry 2

CSV

Each subscription and the date it next renews, lapses or is deleted. Trials and subscriptions in their grace period, suspended or locked come first.

LicenceSubscription IDStatusLicencesStartedNext renewal or endEnds within
Visio Plan 2 lowc-sub-oldSuspended51 Mar 20251 Nov 202630 days
What happens: Suspended: people can't use it, though admins can still back up its data. Reactivate it before this date or it's deleted.
Microsoft 365 Business Premiumc-sub-bpActive101 Mar 202511 Mar 2027Later
What happens: Renews on this date if it's set to renew automatically; otherwise it expires then. Check the billing settings.

Who has which licence 36

CSV

One row for each licence each account holds, and whether it was assigned directly or by a group. Filter by licence to see who has it.

AccountLicenceAssignedGroupsStateUsage locationSign‑in
aaron.watson@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
alfie.roberts@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
alfie.scott@northwindtraders.exampleMicrosoft 365 Business BasicNot knownActiveAllowed
amelia.watson@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
ann.patel@northwindtraders.example lowMicrosoft 365 Business PremiumDirectly and by groupAll StaffActiveGBAllowed
arthur.evans@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
ella.baker@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
ethan.green@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
george.roberts@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
george.robinson@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
grace.taylor@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
grace.wilson@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
hannah.patel@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
hannah.robinson@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
harry.lee@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
imogen.edwards@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
isla.evans@northwindtraders.exampleMicrosoft 365 Business BasicNot knownActiveAllowed
jacob.hughes@northwindtraders.exampleMicrosoft 365 Business BasicNot knownActiveAllowed
leo.evans@northwindtraders.exampleMicrosoft 365 Business BasicNot knownActiveAllowed
leo.morris@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
leo.wright@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
maya.martin@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
megan.lee@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
mia.hughes@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
olivia.scott@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
olivia.smith@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
owen.taylor@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
owen.white@northwindtraders.exampleMicrosoft 365 Business BasicNot knownActiveAllowed
rhys.clark@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
rhys.moore@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
robert.hughes@northwindtraders.exampleMicrosoft 365 Business PremiumBy groupAll StaffActiveBlocked
ruby.hill@northwindtraders.exampleMicrosoft 365 Business BasicNot knownActiveAllowed
ruby.taylor@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
sophie.smith@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed
thomas.clarke@northwindtraders.exampleMicrosoft 365 Business BasicNot knownActiveAllowed
zara.jackson@northwindtraders.exampleMicrosoft 365 Business PremiumNot knownActiveAllowed

Assignment problems 2

CSV

Licences that couldn't be assigned, licensed accounts without a usage location, and licences assigned both directly and by a group.

AccountProblemGroupWhat it meansWhat to do
robert.hughes@northwindtraders.example lowNo usage locationMicrosoft needs a usage location (country) to assign a licence. Groups fall back to the organisation's country; assigning one directly fails.Set the usage location on the account in the Microsoft 365 admin center
ann.patel@northwindtraders.example lowDirectly and by groupAll StaffRemoving the account from the group won't remove the licence, which is how leavers keep licences.Remove the direct assignment so the group manages it

Groups that assign licences 1

CSV

Groups that hand out licences to their members (group-based licensing), how many people have a licence through each and how many assignments failed.

GroupLicences it givesPeople licensed through itErrorsMembersMembership
All StaffMicrosoft 365 Business Premium20Dynamic

Costs use the monthly prices on the Licence prices page. Microsoft doesn't say whether a paid subscription renews automatically: check Billing > Your products in the Microsoft 365 admin center, or Partner Center for subscriptions you sell.

Data from Tenant profile and licences (), Users (), Groups and Teams ().