Request - Help with adding Linux into this report

[Twinter]

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblComputersystem.Domainrole,
tsysOS.OSname,
tblAssets.Domain
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%CrowdStrike_Falcon_Sensor%') And
tblAssets.Lastseen > GetDate() - 4 And tblComputersystem.Domainrole = 1 And
tblAssetCustom.State = 1 And tblAssets.Assettype = -1 And
tblAssets.AssetUnique Not Like '%%'

[Twinter]

Thank you very much that worked and it pulled both Win and Linux which is what I needed

[MikeMc · Accepted solution]

Just a few things:

• I'd recommend a separate report due to how Lansweeper separates Windows and Linux devices.
• I don't scan Linux devices in our environment so the report may or may not be entirely accurate.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblComputersystem.Domainrole,
  tsysOS.OSname,
  tblAssets.Domain
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
  From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
      tblSoftware.softID
  Where tblSoftwareUni.softwareName Like '%CrowdStrike_Falcon_Sensor%' Union All
  Select tblLinuxSoftware.AssetID
  From tblLinuxSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
      tblLinuxSoftware.SoftwareUniID
  Where tblSoftwareUni.softwareName Like '%CrowdStrike_Falcon_Sensor%') And
  tblAssets.AssetID In (Select tblComputersystem.AssetID
  From tblComputersystem Union All Select tblLinuxSystem.AssetID
  From tblLinuxSystem) And tblAssets.Lastseen > GetDate() - 4 And
  (tblComputersystem.Domainrole = 1 Or tblComputersystem.Domainrole Is Null) And
  tblAssetCustom.State = 1