‎03-05-2019 01:06 PM
Select Top 1000000 'domain.gif' As Icon,
tblO365Domain.DomainName,
tblO365Organization.TenantId,
tblO365Domain.AuthenticationType,
tblO365Domain.IsAdminManaged,
tblO365Domain.IsDefault,
tblO365Domain.IsInitial,
tblO365Domain.IsRoot,
tblO365Domain.IsVerified,
tblO365Domain.SupportedServices,
tblO365Domain.State,
tblO365Domain.AvailabilityStatus,
tblO365Organization.DisplayName As Organization
From tblO365Domain
Inner Join tblO365Organization On tblO365Organization.OrganizationId =
tblO365Domain.OrganizationId
Order By tblO365Domain.DomainName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now