→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bobsensor
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
In the configuration tool:
Reports & alerts/report builder
Right click a report/new report

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
In the configuration tool:
Reports & alerts/report builder
Right click a report/new report