Excel Add-In for Azure Active Directory

Build 24.0.9062

UserManagers

UserManagers table for Azure AD data provider.

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 UserId of the manager.
ManagerId [KEY] String The id of the manager.
displayName String The displayName of the manager.
jobTitle String The jobTitle of the manager.
mail String The mail of the manager.
userPrincipalName String The userPrincipalName of the manager.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062