USB Printers

[jmarmo]

Is ther a report I can run that will show all non-network printers or all printers connected USB? My supervisor wants a list of all non-networked printers in the district. The only way way i seem to be able to see them is to select each computer, one at a time and look in devices/printer. There has to be a better way.

[jmarmo]

THANKS.

You guys are the best!

[Hemoco]

Please try this sql code:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblPrinters.Caption,
tblPrinters.EnableBIDI,
tblPrinters.Location,
tblPrinters.Sharename,
tblPrinters.Local,
tblPrinters.Capabilitydescriptions,
tblPrinters.Network,
tblPrinters.Portname
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID
Where tblAssetCustom.State = 1

[jmarmo]

Is there a solution for this?