Select Distinct Top 1000000 tsysAssetTypes.AssetTypeIcon16 As icon,
    tblAssets.AssetID,
    tblAssets.AssetName,
    tblAssets.Domain,
    Case When tblTPM.IsActivated_InitialValue = 0 Then 'Deactivated0'
      When tblTPM.IsActivated_InitialValue = 1 Then 'Activated1'
      Else 'Not Present' End As TPMActivation,
    tblOperatingsystem.Caption As OS,
    tblAssets.Username,
    tblAssets.IPAddress,
    tblAssetCustom.Manufacturer,
    tblAssetCustom.Model,
    tblAssets.Lastseen,
    tblAssets.Lasttried
  From tblAssets
    Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
    Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
    Inner Join tblSystemEnclosure On tblSystemEnclosure.AssetID =
      tblAssets.AssetID
    Left Join tblTPM On tblAssets.AssetID = tblTPM.AssetId
    Left Join tblOperatingsystem
      On tblAssets.AssetID = tblOperatingsystem.AssetID
  Where tblSystemEnclosure.ChassisTypes In ('8', '9', '10', '21', '31', '32')
  Order By tblAssets.AssetName