Spot The Difference - Two similar reports with two very different outcomes.

[markatwork]

Hey folks,

I'm very new to lansweeper. After some self-taught trial and error I have a report (NEW) that gets me some desired information. However, it is only getting it for Windows devices and I do not know why. The report it is based on (OLD) also captured non-Windows devices such as networking equipment and Linux. I've done comparisons but cannot figure it out.

Please could someone help so I can use the NEW to capture non Windows devices too?

NEW

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.Lastseen,
  tblAssets.Description,
  tblAssetCustom.State,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber,
  tblAssets.AssetUnique,
  tblAssets.FQDN,
  tblAssets.SiteID,
  tblAssets.Assettype,
  tblAssets.Firstseen,
  tblOperatingsystem.Caption,
  tblOperatingsystem.OSType,
  tblOperatingsystem.ServicePackMajorVersion,
  tblOperatingsystem.Version,
  HostAssets.AssetName As VMHostAssetName,
  tblAssets.OScode,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Location,
  tblAssets.Memory,
  tblAssets.NrProcessors,
  tblAssets.Processor,
  Sum(Distinct tblDiskdrives.Size / Power(10,
  9)) As [Provisioned Capacity (GB)],
  Sum(Distinct tblDiskdrives.Freespace / Power(10, 9)) As [Free Capacity (GB)]
From tblAssets
  Left Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tblOperatingsystem On tblAssets.AssetID = tblOperatingsystem.AssetID
  Left Join tblVmwareGuest On tblAssets.AssetName = tblVmwareGuest.Name
  Left Join tblAssets HostAssets On tblVmwareGuest.AssetID = HostAssets.AssetID
  Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
  Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
  Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Group By tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10,
  tblAssets.Lastseen,
  tblAssets.Description,
  tblAssetCustom.State,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber,
  tblAssets.AssetUnique,
  tblAssets.FQDN,
  tblAssets.SiteID,
  tblAssets.Assettype,
  tblAssets.Firstseen,
  tblOperatingsystem.Caption,
  tblOperatingsystem.OSType,
  tblOperatingsystem.ServicePackMajorVersion,
  tblOperatingsystem.Version,
  HostAssets.AssetName,
  tblAssets.OScode,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Location,
  tblAssets.Memory,
  tblAssets.NrProcessors,
  tblAssets.Processor
Order By tblAssets.AssetID

 OLD

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssets.Username,
  tblAssets.Domain,
  tblAssets.Description,
  tblAssetCustom.State,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber,
  tblAssets.AssetUnique,
  tblAssets.FQDN,
  tblAssets.Userdomain,
  tblAssets.SiteID,
  tblAssets.Assettype,
  tblAssets.Firstseen,
  tblOperatingsystem.Caption,
  tblOperatingsystem.OSType,
  tblOperatingsystem.ServicePackMajorVersion,
  tblOperatingsystem.Version,
  HostAssets.AssetName As VMHostAssetName,
  tblAssets.OScode,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Location
From tblAssets
  Left Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tblOperatingsystem On tblAssets.AssetID = tblOperatingsystem.AssetID
  Left Join tblVmwareGuest On tblAssets.AssetName = tblVmwareGuest.Name
  Left Join tblAssets HostAssets On tblVmwareGuest.AssetID = HostAssets.AssetID
Order By tblAssets.AssetID

Many thanks!

[KevinA-REJIS]

I might be mistaken (if so, please correct me), but it's possible that one of the selected columns and/or Inner Joins are Windows-specific which would limit the results to only Windows assets. You might be able to do a Union with another Select query for Linux/Mac assets as long as they have equivalent columns, if not you'd need to either limit it to the columns they do have or create separate reports.