→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

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 !