cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
harringg
Champion Sweeper
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
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
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.

View solution in original post

2 REPLIES 2
harringg
Champion Sweeper
Thank you. That produced the report I was looking for.
Susan_A
Lansweeper Alumni
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.