Select Top 1000000 'user.png' As Icon,
tblO365User.DisplayName,
tblO365User.UserPrincipalName,
tblADusers.Username,
tblADusers.Userdomain,
tblO365User.Department,
tblO365User.Mail,
tblO365Organization.DisplayName As Organization,
tblO365Organization.TenantId
From tblO365User
Inner Join tblO365Organization On tblO365User.OrganizationId =
tblO365Organization.OrganizationId
Left Outer Join tblADusers On tblADusers.UPN = tblO365User.UserPrincipalName
Where tblO365User.PasswordPolicies = 'DisableStrongPassword'
Order By tblO365User.DisplayName
Explore the full platform, free for 14 days.
No credit card required.