Search by Monitor Seral Number

[ABECU]

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.

[Hemoco]

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'