JDBC Driver for Azure Active Directory

Build 24.0.9175

DirectoryRoleTemplates

Offers a template view of all directory roles available for use within Azure AD.

Table Specific Information

Select

Most filters are handled server side, but the specific field of Id will change the endpoint we use to retrieve the data. It must be specified with an '=' or IN condition. For example:

SELECT * FROM DirectoryRoleTemplates WHERE Id = '62e90394-69f5-4237-9190-012177145e10'
SELECT * FROM DirectoryRoleTemplates WHERE Id IN ('62e90394-69f5-4237-9190-012177145e10', '2af84b1e-32c8-42b7-82bc-daa82404023b')
SELECT * FROM DirectoryRoleTemplates WHERE DisplayName LIKE '%Admin%'

Columns

Name Type Description
id [KEY] String The unique identifier for the directory role template, typically used as the primary key.
deletedDateTime Datetime The timestamp indicating when the directory role template was deleted, useful for auditing and recovery.
description String A detailed explanation or notes about the purpose and scope of the directory role template.
displayName String The human-readable name of the directory role template, used for display in user interfaces.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175