→ 🚀Are you a Lansweeper Champion?! Join our Contributor Program Sign up here!

Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
itdpt
Engaged Sweeper
Hello,

I need to find out who has a particular tipe of display, tried to do a search but it didn't work.

how can i do a custom report that shows me up which Machines or users have a particular display model attacched ?

Thank You
2 REPLIES 2
Hemoco
Lansweeper Alumni
Monitor info is kept in tblMonitor.


Basic report:

Select tblComputers.Computername, tblComputers.Computer, tblComputers.Domain,
tblMonitor.MonitorModel, tblMonitor.SerialNumber,
tblMonitor.MonitorManufacturer
From tblComputers Left Join
tblMonitor On tblComputers.Computername = tblMonitor.Computername
Order By tblComputers.Computer
itdpt
Engaged Sweeper
Figured Out !

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now