cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Default Printer Report

wizard210
Engaged Sweeper
Is there a report that will tell me what the default printer is set to on my users workstations?
4 REPLIES 4

mhammond
Champion Sweeper
Necro'd this, sorry...

It would be nice to be able to have this added to the Asset Page, under Devices > Printers ... say like a green checkbox next to the default printer, or the font bolded or something eye-catching....

mlachance
Engaged Sweeper III
Under Scanning -> File & Registry Scanning, add:
HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows\Device


Then create a report with the following:
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


This will give you the Assetname, Username, and current default printer association for the user.

comtcjm
Engaged Sweeper II
Anyone managed this yet?

mikerwolf
Engaged Sweeper
Bump, I'm looking for something exactly like this as well!