cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
AlexMZetec
Engaged Sweeper II
Hello all!

I have a report that show me computer list with their tblTPM.SpecVersion.
But the report doesn't show me computers with NO tblTPM.SpecVersion. It only show computers with a tblTPM.SpecVersion.
I would like to see all computers with or without tblTPM.SpecVersion.
How do I tell to show all even if empty?

In advance thx for your help!


Select Top 1000000 tsysAssetTypes.AssetTypeIcon16 As icon,
tblAssets.AssetName,
Case
When tblDiskPartition.Bootable = 'True' And tblDiskPartition.Type =
'Installable File System' Then 'Legacy'
When tblDiskPartition.Bootable = 'True' And tblDiskPartition.Type <>
'Installable File System' Then 'UEFI'
End As BiosType,
Case
When tblEncryptableVolume.ProtectionStatus = 0 Then 'OFF'
When tblEncryptableVolume.ProtectionStatus = 1 Then 'ON'
Else 'UNKNOWN'
End As ProtectionStatus,
tblEncryptableVolume.DriveLetter,
tsysOS.OSname As OS,
tblAssets.SP As SP,
tblAssets.Username,
tblAssetCustom.State,
tblTPM.SpecVersion
From tblEncryptableVolume
Inner Join tblAssets On tblEncryptableVolume.AssetId = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblDiskPartition On tblAssets.AssetID = tblDiskPartition.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblTPM On tblAssets.AssetID = tblTPM.AssetId
Where (tblAssets.AssetName Like 'QC-%' Or tblAssets.AssetName Like 'FR-%') And
Case
When tblDiskPartition.Bootable = 'True' And tblDiskPartition.Type =
'Installable File System' Then 'Legacy'
When tblDiskPartition.Bootable = 'True' And tblDiskPartition.Type <>
'Installable File System' Then 'UEFI'
End Is Not Null And tblEncryptableVolume.DriveLetter = 'C:' And
tblAssetCustom.State = 1
Order By tblAssets.AssetName
1 ACCEPTED SOLUTION
RCorbeil
Honored Sweeper II
By definition, the INNER JOIN against tblTPM is saying "only show me records where there exists a corresponding entry in the tblTPM table". Try changing it to a LEFT JOIN, "show me all records including, if there happens to exist anything there, values from tblTPM".

View solution in original post

2 REPLIES 2
AlexMZetec
Engaged Sweeper II
It works!
Wonderful!

1000 thank you!


RCorbeil
Honored Sweeper II
By definition, the INNER JOIN against tblTPM is saying "only show me records where there exists a corresponding entry in the tblTPM table". Try changing it to a LEFT JOIN, "show me all records including, if there happens to exist anything there, values from tblTPM".

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now