Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData Excel Add-In for Microsoft Entra ID Views


Name	Description
AdministrativeUnitMembers	Lists all members of administrative units available to the authenticated user, providing details on their membership relationships.
AdministrativeUnits	Displays a comprehensive list of administrative units accessible to the authenticated user, enabling management of organizational structure.
CompanySubscriptions	Represents a commercial subscription for a tenant.
Contacts	Provides access to the organizational contact list, including external and internal contact details.
Contracts	Presents all active contracts for the authenticated user, detailing subscription and agreement terms.
DeviceLocalCredentials	Offers information on local administrator account credentials for specific device objects.
DeviceRegisteredOwners	Maps device objects to their registered owners for tracking and management purposes.
DeviceRegisteredUsers	Associates device objects with their registered users, facilitating detailed user-device relationship analysis.
DirectoryAudits	Tracks and lists all directory audit events accessible to the authenticated user for compliance and monitoring.
DirectoryRoleMembers	Identifies the members assigned to specific directory roles.
DirectoryRoles	Contains a list of directory roles, detailing roles assigned to users and groups within the organization.
DirectoryRoleTemplates	Offers a template view of all directory roles available for use.
EmailAuthenticationMethods	Returns the email authentication methods registered for a user, including the associated email address.
Fido2AuthenticationMethods	Returns the FIDO2 security key authentication methods registered for a user, including device model, attestation, and creation details.
GroupApplicationRoleAssignments	Tracks application role assignments assigned to specific groups for managing permissions.
GroupMembers	Provides a detailed view of group memberships, listing all members of each group within the organization.
MFAStatuses	Lists MFA statuses for users within the organization.
MicrosoftAuthenticatorAuthenticationMethods	Returns the Microsoft Authenticator app authentication methods registered for a user, including device and app version details.
Organization	Contains metadata and details about the organization accessible to the authenticated user.
PasswordAuthenticationMethods	Returns the password authentication methods registered for a user, including the creation date of each method.
PhoneAuthenticationMethods	Lists phone-based authentication methods configured for users within the organization.
PlatformCredentialAuthenticationMethods	Returns the platform credential authentication methods registered for a user, including platform, key strength, and creation details.
ProfileCardProperties	Retrieves custom properties displayed on user profile cards within the organization.
RiskDetections	Returns risk detections identified by identity protection, including detection type, risk level, activity, and location details.
RiskyServicePrincipals	Returns service principals flagged as risky by identity protection, including risk level, risk state, and processing status.
RiskyUserHistory	Returns the risk history of risky users, including the changes to risk level, risk state, and the activity that initiated each change.
RiskyUsers	Returns users flagged as risky by identity protection, including risk level, risk state, and processing status.
RoleAssignments	Displays all configured role assignments.
RoleDefinitions	Provides definitions for roles available, detailing their permissions and scope.
ServicePrincipalRiskDetections	Returns risk detections associated with service principals, including detection type, risk level, activity, and location details.
SignIns	Tracks and lists all user sign-in activities for audit and monitoring purposes.
SoftwareOathAuthenticationMethods	Returns the software OATH token authentication methods registered for a user, including the associated secret key.
SubscribedSKUs	Lists service subscriptions (SKUs) the organization is subscribed to, including details of usage and availability.
TemporaryAccessPassAuthenticationMethods	Returns the temporary access pass authentication methods registered for a user, including lifetime, usability, and validity details.
UserApplicationRoleAssignments	Tracks application role assignments assigned to specific users for managing access and permissions.
UserManagers	Maps users to their assigned managers within the organization for reporting and hierarchy management.
UserMemberships	Provides details of group and directory role memberships for specific users within the organization.
WindowsHelloForBusinessAuthenticationMethods	Returns the Windows Hello for Business authentication methods registered for a user, including key strength and creation details.