Hello,

I have seen this post to report locally installed printers

SELECT
tblcomputers.ComputerUnique,
tblPrinters.Caption,
tblPrinters.Portname,
tblPrinters.Sharename,
tblPrinters.Location,
tblPrinters.Comment
FROM
tblcomputers
INNER JOIN tblPrinters ON (tblcomputers.Computername = tblPrinters.Computername)
WHERE
tblPrinters.Caption NOT LIKE 'Microsoft%' AND
tblPrinters.Caption NOT LIKE 'CutePDF%' AND
tblPrinters.Caption NOT LIKE 'FAX' AND
tblPrinters.Caption NOT LIKE 'Adobe%'


I would like to have the exact same thing.

question: how do I add custom queries

I probably need to edit an sql file and table, but wich one?

thank you
bob