Fabrikam Dental Group
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| anna.kowalski@fabrikam.example medium | Anna Kowalski | Member | Allowed | Sales | Sales lead | Ben Okafor | Microsoft 365 Business Premium | Cloud | 30 Sep 2026 | |
| ben.okafor@fabrikam.example | Ben Okafor | Member | Blocked | Microsoft 365 Business Premium | Cloud | Never | ||||
| g#EXT#@fabrikam.example | Sam Carter (guest) | Guest | Allowed | Cloud | Never |
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 |
|---|---|---|---|---|---|
| ruby.clark@fabrikam.example | Ruby Clark | Allowed | Projects | 5 | Amelia Jackson, Owen Khanand 3 moreOwen Patel, Ruby Davies, William Wood |
Member accounts by department, as set on each account. Guests are left out.
| Members | Sign-in allowed | Licensed | No manager |
|---|---|---|---|
| 6 | 6 | 6 | 0 |
| 7 | 7 | 7 | 0 |
| 6 | 6 | 6 | 0 |
| 7 | 7 | 7 | 0 |
| 7 | 7 | 7 | 0 |
| 6 | 6 | 6 | 0 |
| 6 | 6 | 6 | 0 |
| 8 | 8 | 8 | 0 |
| 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 ().