cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
BB-VV
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
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