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
