→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
AlexRus227
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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.

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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.