I think that I have a report that finally like. took a bit to create this
Select Top 1000000 'user.png' As Icon,
tblO365User.DisplayName,
tblO365User.UserPrincipalName,
tblADusers.Username,
tblADusers.Userdomain,
tblO365User.Department,
tblO365User.Mail,
tblO365Organization.DisplayName As Organization,
tblO365Sku.DisplayName As LicensePlan,
tblAssets.AssetName,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssets.Processor,
Ceiling(tblAssets.Memory / 1024) As [RAM in GB],
tsysOS.OSname
From tblO365User
Inner Join tblO365Organization On tblO365User.OrganizationId =
tblO365Organization.OrganizationId
Left Outer Join tblADusers On tblADusers.UPN = tblO365User.UserPrincipalName
Left Join tblO365License On tblO365Organization.OrganizationId =
tblO365License.OrganizationId
Inner Join tblO365AssignedLicense On tblO365License.LicenseId =
tblO365AssignedLicense.LicenseId And tblO365AssignedLicense.UserId =
tblO365User.UserId
Left Join tblO365Sku On tblO365Sku.Name = tblO365License.SkuPartNumber
Left Join tblAssets On tblAssets.username = tblADusers.username
Left Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where (tblO365Sku.DisplayName = 'Office 365 Business Premium' Or
tblO365Sku.DisplayName = 'Enterprise Plan E3' Or tblO365Sku.DisplayName =
'Enterprise Plan E1')
Order By tblO365User.DisplayName
This report tells me what O365 licensed users I have in lansweeper, gives me the asset name, model, processor, etc
now I am trying to get the drive capacity and free space figured out.