‎03-05-2019 01:06 PM
Select Top 1000000 'license.png' As Icon,
tblO365AssignedPlan.Service,
tblO365AssignedPlan.CapabilityStatus,
tblO365AssignedPlan.AssignedTimeStamp,
tblO365User.DisplayName As UserDisplayName,
tblO365Organization.DisplayName As Organization,
tblO365Organization.TenantId
From tblO365AssignedPlan
Left Outer Join tblO365User On tblO365User.UserId = tblO365AssignedPlan.UserId
Inner Join tblO365Organization On tblO365AssignedPlan.OrganizationId =
tblO365Organization.OrganizationId
Order By tblO365AssignedPlan.Service
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now