Report of Windows shared printers and their respective driver name

[Glenn_Gagne]

Hi,

I searched on the web and tested many things before posting this request... but I didn't found a solution.

Actually, I can easly generate a report where I can find all shared printers on my Windows machine using this perfect report: Shared Printers - Lansweeper

I can also easly list all installed drivers on all machines

I can also see all printers (shared or not) AND the respective "Driver name" on a Windows machine, asset per asset via: Asset(s) ->Config -> Devices -> Printer

But I was not able to create a report like Shared Printers - Lansweeper where I could simply add a column with the "Driver name" used for each shared printers.

Please help me 🙂

[Mister_Nobody]

Try this:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.Domain,
  tblAssets.AssetUnique,
  tblAssets.oscode,
  tblSharesUni.Name As [Share Name],
  tblShares.Lastchanged As [Share Lastchanged],
  tblPrinters.Caption As [Printer Name],
  tblPrinterDriverDevice.Name As [Printer Driver Name],
  tblPrinters.Portname,
  tblPrinterDrivers.DriverVersion,
  tblPrinterDrivers.DriverDate
From tblShares
  Inner Join tblAssets On tblShares.AssetID = tblAssets.AssetID
  Inner Join tblSharesUni On tblShares.ShareUniqueID =
      tblSharesUni.ShareUniqueID
  Inner Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID And
      tblPrinters.Caption = tblSharesUni.Caption
  Left Join tblPrinterDriverDevice On
      tblAssets.AssetID = tblPrinterDriverDevice.AssetID And
      tblPrinters.DeviceID = tblPrinterDriverDevice.DeviceID
  Left Join tblPrinterDriversUni On tblPrinterDriverDevice.Name =
      tblPrinterDriversUni.Name
  Left Join tblPrinterDrivers On tblAssets.AssetID = tblPrinterDrivers.AssetID
      And tblPrinterDriversUni.PrinterDriverUniID =
      tblPrinterDrivers.PrinterDriverUniID
Where tblSharesUni.Type = 1
Order By tblAssets.AssetName