UserManagers
Maps users to their assigned managers within the organization for reporting and hierarchy management.
Table Specific Information
Select
Get the manager of users in your Azure Active Directory. You can filter results by UserId.
- UserId supports the '=' and IN operators.
For example, the following queries are processed server side:
SELECT * FROM UserManagers WHERE UserId = 'ffacf701-6caf-4228-9e3b-7e57c14122ee'
SELECT * FROM UserManagers WHERE UserId IN (SELECT Id FROM Users)
Columns
| Name | Type | Description |
| UserId [KEY] | String | The unique identifier for the user associated with the manager. |
| ManagerId [KEY] | String | The unique identifier for the manager overseeing the user. |
| displayName | String | The full display name of the manager, typically used for identification in user interfaces. |
| jobTitle | String | The professional job title of the manager, indicating their role or position within the organization. |
| String | The primary email address of the manager, used for communication purposes. | |
| userPrincipalName | String | The principal username of the manager, typically formatted as an email address and used for sign-in. |