How to make a report on network printer

[AlexRus227]

Which computer is connected to a network printer ?

I add search registry Printers\Connections\,,print2,1J Xerox 7500 a

and

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tblRegistry.Regkey,
  tblRegistry.Valuename,
  tblRegistry.Value,
  tblRegistry.Lastchanged,
  tblAssets.Username
From tblAssets
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where tblRegistry.Regkey Like '%Printers\Connections\,,print2,1J Xerox 7500'
Order By tblAssets.AssetUnique

Please How to add Username = DisplayName

[Hemoco · Accepted solution]

It would be better/easier to create an asset report based on tblPrinters. User display names are stored in tblADusers, which must be linked to tblAssets on both the Username and Userdomain fields.