Harbour ITMenu

Powered by Office Sentry 2.3.0

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 2Renewals and expiry 2Who has which licence 36Assignment problems 2Groups that assign licences 1

Subscriptions 2 of 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.

Flag: No flagRemove Clear filters
By licenceAssignedAvailable
  1. Microsoft 365 Business Premium32
  2. Microsoft 365 Business Basic9
LicenceStatusPurchasedAssignedAvailablePrice / monthCost / monthNext renewal or endTrial
Microsoft 365 Business BasicActive972£4.90£44.10No
Microsoft 365 Business PremiumActive32293£18.10£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.

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

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.

AccountLicenceProblemGroup
robert.hughes@northwindtraders.example lowMicrosoft 365 Business PremiumNo usage location
What it means: Microsoft needs a usage location (country) to assign a licence. Groups fall back to the organisation's country; assigning one directly fails.What to do: Set the usage location on the account in the Microsoft 365 admin center
ann.patel@northwindtraders.example lowMicrosoft 365 Business PremiumDirectly and by groupAll Staff
What it means: Removing the account from the group won't remove the licence, which is how leavers keep licences.What to do: 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 ().