‎05-22-2017 08:41 PM
‎06-09-2022 10:22 PM
‎09-28-2017 06:16 PM
HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows\Device
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssets.Domain,
Left(tblRegistry.Value, CharIndex(',', tblRegistry.Value)) As 'Printer Name',
tblRegistry.Lastchanged
From tblAssets
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where
tblRegistry.Regkey Like
'%Software\Microsoft\Windows NT\CurrentVersion\Windows%' And
tblRegistry.Valuename Like '%Device%'
Order By tblAssets.AssetName
‎09-28-2017 04:02 PM
‎06-06-2017 07:48 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now