Getting Error when trying to create a report that targets whether a reg key exists

[tasutton]

Great Afternoon All,

How are you ? Great I hope ! 

I am getting these errors when trying to run the attached report, please advise.

The multi-part identifier "tblAsset.AssetID" could not be bound.

Invalid column name 'Found'.

Thanks and have a great rest of the week ! 

Tony

[DavidPK]

Hi,

You can try this query.

Select Top 1000000 
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.IPAddress,
  tblAssets.Username,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssets.Lastseen
From tblAssets
  Inner Join tblSystemEnclosure On tblSystemEnclosure.AssetID = tblAssets.AssetID
  Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype = tblSystemEnclosure.ChassisTypes
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1 
  And (TsysChassisTypes.ChassisName In ('Laptop', 'Notebook', 'Portable', 'Desktop'))
  And tblAssets.AssetID Not In (
    Select tblRegistry.AssetID 
    From tblRegistry
    Where tblRegistry.Regkey = 'HKLM\SOFTWARE\WOW6432Node\Cisco\Cisco Secure Client\ThousandEyes Endpoint Agent' 
      And tblRegistry.Valuename = 'AccountToken'
  )
Order By tblAssets.AssetName

[tasutton]

Great Evening David,

How are you ? Great I hope ! 

Thanks, the query ran without error, but it is not isolating machines missing the Registry key, it is showing all machines. Assets: Computers With Cisco ThousandEyes NOT Registered  (912). the number reported should be under 40 machines. 

From your reply, it appears, that it is not possible to use the tblRegistry.Found = 'False' statement

Also how would I integrate this statement so that the query does not show Virtual machines ? 

Where tblassetcustom.Model Not Like '%Virtual Machine%'

Thanks you very much, I appreciate all of your help ! 

Have a great evening Sir ! 

Tony