Kaseya Community

Printer Audits

  • Does anyone know a way to get a report of local printers only on a network/group?

  • Hi,

    this SQL request should cover your need

    SELECT TOP 1000 p.[emailAddr]

         ,p.[agentGuid]

         ,p.[resultGroup]

         ,p.[locked]

         ,p.[printerName]

         ,p.[portName]

         ,p.[model]

         ,p.[status]

         ,p.[attributes]

         ,m.groupName

         ,m.machName

         ,m.SysSerialNumber

     FROM [ksubscribers].[dbo].[auditRsltPrinters] as P

     join vMachine as m on m.agentGuid = P.agentGuid

     where m.groupName = 'xxx'