Northwind Traders
Every member and guest account. Accounts that report to someone whose sign-in is blocked are flagged: the manager has usually left, so approvals and HR records go nowhere.
| Account | Name | Type | Sign-in | Department | Job title | Manager | Licences | Source | Created | Last sign-in |
|---|---|---|---|---|---|---|---|---|---|---|
| hannah.robinson@northwindtraders.example | Hannah Robinson | Member | Allowed | Operations | Head of Operations | Ann Patel | Microsoft 365 Business Premium | Cloud | 5 Aug 2026 | 7 Apr 2026 |
| sophie.smith@northwindtraders.example | Sophie Smith | Member | Allowed | Sales | Head of Sales | Ann Patel | Microsoft 365 Business Premium | Cloud | 29 Jun 2026 | 21 Jan 2026 |
Everyone who is someone's manager, with the accounts that report to them. A manager whose sign-in is blocked still has people reporting to them: update the manager in Entra ID (or on-premises AD, for synced accounts).
| Manager | Name | Sign-in | Direct reports | Reports |
|---|---|---|---|---|
| grace.taylor@northwindtraders.example | Grace Taylor | Allowed | 3 | Alfie Roberts, George Robinson, Isla Evans |
Member accounts by department, as set on each account. Guests are left out.
| Department | Members | Sign-in allowed | Licensed | No manager |
|---|---|---|---|---|
| Customer Service | 4 | 4 | 4 | 0 |
| Finance | 5 | 5 | 5 | 0 |
| HR | 4 | 4 | 4 | 0 |
| Marketing | 4 | 4 | 4 | 0 |
| Operations | 5 | 5 | 5 | 0 |
| Projects | 4 | 4 | 4 | 0 |
| Reception | 4 | 4 | 4 | 0 |
| Sales | 5 | 5 | 5 | 0 |
| No department | 1 | 0 | 1 | 0 |
Departments, job titles and managers are whatever is set on each account in Entra ID (or in on-premises AD, for synced accounts). Last sign-in is the latest of interactive and background sign-ins, and needs Entra ID P1.
Data from Users (), Departments and managers (), Tenant profile and licences ().