Chassis report to include non-scanned PCs

[harringg]

I've got this report working in which I'm trying to list chassis type and serial number of scanned PCs.

I have some PCs that are entered in LS manually and listed as Windows, but have not been scanned (off-network, and no time to scan with LSPush)

Is there a way to have those showup as well in this report? Or will it require a second standalone report?

I realize that if the assest has not been scanned, there won't be a value in the ChassisName, but would like it listed in the inventory report, since the PC is physical property.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  TsysChassisTypes.ChassisName,
  tblAssetCustom.Serialnumber,
  tblAssetCustom.Contact As [Primary User],
  tblAssets.Username As [Login Account],
  tblAssetCustom.Location,
  tblAssetCustom.Building,
  tblAssetCustom.Department,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblstate.Statename,
  tblAssetCustom.Custom16 As [CONFIRM-VISUAL]
From tblAssets
  Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
  Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
    tblAssetGroupLink.AssetGroupID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblSystemEnclosure
    On tblAssets.AssetID = tblSystemEnclosure.AssetID
  Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
    tblSystemEnclosure.ChassisTypes
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblstate On tblstate.State = tblAssetCustom.State
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblAssetGroups.AssetGroup Like 'Default group'
Order By tblAssets.IPNumeric

[harringg]

Thank you. That produced the report I was looking for.

[Susan_A · Accepted solution]

Right-click on the links between tblAssets and tblSystemEnclosure, tsysOS and tblOperatingsystem (i.e. any table that contains scanned data and that will not be populated for manually created assets) and tick "select all rows from tblAssets", which will change the Inner Joins to Left Joins. Also right-click on the link between tblSystemEnclosure and tsysChassisTypes and tick "select all rows from tblSystemEnclosure". Lansweeper uses standard SQL queries. This article explains how joins work.