Domains

Displays all domains registered and verified within the organization, along with their configurations.

Table-Specific Information

SELECT

You can query Domains by either specifying an Id or selecting all:

SELECT * FROM Domains WHERE Id = 'rssbus.cn'
SELECT * FROM Domains

Filter results using the LIKE operator:

SELECT Id FROM Domains WHERE Id LIKE '%rssbus%'

INSERT

Specify an Id in order to create a new domain. The Id should be the name of the new domain:

INSERT INTO Domains (Id) VALUES ('cdata.com')

UPDATE

To update a Domain record, you must specify the Id in the WHERE clause.

UPDATE Domains SET passwordNotificationWindowInDays = 14 WHERE Id = 'cdata.com'

DELETE

To delete a Domain record, you must specify the Id in the WHERE clause.

DELETE FROM Domains WHERE Id = 'cdata.com'

Columns


Name	Type	ReadOnly	Description
id [KEY]	String	False	The unique identifier of the domain, used to reference it in the directory.
authenticationType	String	False	Specifies whether the type of authentication supported by the domain, such as 'Managed' or 'Federated'.
availabilityStatus	String	False	Indicates whether the domain is available and properly configured within Microsoft Entra ID.
isAdminManaged	Bool	False	Indicates whether the domain is managed and controlled by an administrator.
isDefault	Bool	False	Specifies whether the domain is set as the default domain for the directory.
isInitial	Bool	False	Shows whether the domain was the initial domain created for the directory.
isRoot	Bool	False	Denotes whether the domain is a root domain within the directory hierarchy.
isVerified	Bool	False	Indicates whether the domain has been verified with Microsoft Entra ID.
passwordNotificationWindowInDays	Int	False	The number of days before password expiration when a notification is sent to users.
passwordValidityPeriodInDays	Int	False	The duration, in days, for which passwords associated with the domain remain valid.
state_lastActionDateTime	Datetime	False	The timestamp of the last action performed on the domain's state.
state_operation	String	False	Describes the most recent operation performed on the domain's state, such as 'Verify' or 'Update'.
state_status	String	False	The current status of the domain's state operation, such as 'InProgress', 'Completed', or 'Failed'.
supportedServices	String	False	A list of services supported by the domain, such as Exchange or SharePoint.