Report registry file with hostname

[dwieszczak]

Could someone help me create a report that outputs the String value of a of a registry key and the hostname of the PC? I have configured to scan HKLM\System\AssetTag\ in the LanSweeper configuration manager.

location of string: HKLM\System\AssetTag\
string name: AssetTag
string value: "numeric value"

[Hemoco]

Select tblComputers.Computername, tblRegistry.Value,
  tblComputerSystemProduct.IdentifyingNumber
From tblComputers Inner Join
  tblRegistry On tblComputers.Computername = tblRegistry.Computername Inner Join
  tblComputerSystemProduct On tblComputers.Computername =
    tblComputerSystemProduct.Computername
Where tblRegistry.Valuename = 'Assettag'     

[dwieszczak]

could you add the Dell serice tag to the report? Thanks.

[Hemoco]

Select tblComputers.Computername, tblRegistry.Value
From tblComputers Inner Join
  tblRegistry On tblComputers.Computername = tblRegistry.Computername
Where tblRegistry.Valuename = 'Assettag'