List all shared printers in your network easily with the built-in report. Don’t miss out on any hidden shared printers. Lansweeper retrieves shared printers from Windows computers and by using the report below you get an overview of all the shared printers found in your environment.
Shared Printers Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Description,
tsysOS.OSname,
tblSharesUni.Name,
tblSharesUni.Path,
tblShares.Lastchanged,
tsysOS.Image As icon
From tblShares
Inner Join tblAssets On tblShares.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblSharesUni On tblShares.ShareUniqueID =
tblSharesUni.ShareUniqueID
Where tblAssetCustom.State = 1 And tblSharesUni.Type = 1
Order By tblAssets.AssetName
