Domains

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

Table Specific Information

Select

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

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

Select a certain column from the entity and filter by that column:

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 need to specify the Id in WHERE clause.

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

Delete

To delete a Domain record, you need to specify the Id in 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 Azure Active Directory.
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 Azure Active Directory.
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.