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 | Licences | Last sign‑in |
|---|---|---|---|---|---|---|---|
| ethan.green@ | Ethan Green | Member | Allowed | Projects | Project manager | Microsoft 365 Business Premium | 12 Oct 2026 |
| jacob.hughes@ | Jacob Hughes | Member | Allowed | Projects | Project manager | Microsoft 365 Business Basic | 11 Oct 2026 |
| maya.martin@ | Maya Martin | Member | Allowed | Projects | Project manager | Microsoft 365 Business Premium | 12 Oct 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 | Department | Direct reports | Reports |
|---|---|---|---|---|---|
| robert.hughes@ | Robert Hughes | Blocked | 1 | Ann Patel | |
| ann.patel@ | Ann Patel | Allowed | Sales | 8 | Grace Taylor, Hannah Robinson + 6 more
|
| grace.taylor@ | Grace Taylor | Allowed | Customer Service | 3 | Alfie Roberts, George Robinson, Isla Evans |
| hannah.robinson@ | Hannah Robinson | Allowed | Operations | 4 | Alfie Scott, Imogen Edwards + 2 more
|
| megan.lee@ | Megan Lee | Allowed | Marketing | 3 | Amelia Watson, Ella Baker, Leo Morris |
| olivia.smith@ | Olivia Smith | Allowed | Reception | 3 | Arthur Evans, George Roberts, Ruby Hill |
| owen.white@ | Owen White | Allowed | HR | 3 | Hannah Patel, Olivia Scott, Owen Taylor |
| ruby.taylor@ | Ruby Taylor | Allowed | Projects | 3 | Ethan Green, Jacob Hughes, Maya Martin |
| sophie.smith@ | Sophie Smith | Allowed | Sales | 3 | Leo Evans, Leo Wright, Rhys Clark |
| thomas.clarke@ | Thomas Clarke | Allowed | Finance | 4 | Aaron Watson, Grace Wilson + 2 more
|
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 | 2 | 1 | 1 | 1 |
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 ().