How to show manually created assets in reports?

[BB-VV]

Hello,

I've created the following Report. But it's not showing manually created assets. Can anybody see the problem?

Select Top 1000000 tblAssets.AssetUnique,
tsysOS.OSname,
tsysOS.Image As icon,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssets.Username,
tblAssets.Description As Computerdescription,
tblAssetCustom.Custom1 As [IV-Nummer],
tblAssetCustom.Custom2 As [IV-Besitzer],
tblAssetCustom.Custom3 As [IV-Datum],
tblAssetCustom.Custom4 As [IV-Abteilung],
tblAssets.Firstseen,
tblAssets.Lastseen,
tblState.Statename,
tblAssets.AssetID
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblAssetCustom tblAssetCustom1 On tblAssets.AssetID =
tblAssetCustom1.AssetID And tblState.State = tblAssetCustom1.State
Order By tblAssets.AssetName

[Daniel_B · Accepted solution]

You added tsysOS to your report. This table only has entries for Windows computers which successfully were scanned. If you would like to list all assets, you need to change the join between tblAssets and tsysOS to a Left Join (select all rows from tblAssets). In the modified report below we also removed a duplicate version of tblAssetCustom.

Select Top 1000000 tblAssets.AssetUnique,
  tsysOS.OSname,
  tsysOS.Image As icon,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.PurchaseDate,
  tblAssetCustom.Warrantydate,
  tblAssets.Username,
  tblAssets.Description As Computerdescription,
  tblAssetCustom.Custom1 As [IV-Nummer],
  tblAssetCustom.Custom2 As [IV-Besitzer],
  tblAssetCustom.Custom3 As [IV-Datum],
  tblAssetCustom.Custom4 As [IV-Abteilung],
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblState.Statename,
  tblAssets.AssetID
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblState On tblState.State = tblAssetCustom.State
Order By tblAssets.AssetName