cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ABECU
Engaged Sweeper III
Is there any way to be able to search for a monitor serial number? Typing a PC's serial into the search bar brings it up, but monitor serials do not. We'd like to be able to see which PC is connected to a specific monitor. Thank you.
1 REPLY 1
Hemoco
Lansweeper Alumni
Such a search is not currently possible through the web console. It can be performed through the report builder however, using the SQL code below. Replace "YourSerial" with the serial number you wish to search for.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblMonitor.SerialNumber
From tblComputers Inner Join
tblMonitor On tblComputers.Computername = tblMonitor.Computername
Where tblMonitor.SerialNumber = 'YourSerial'