LCD TV details

[Srikanth08]

Hi,

is there any wat to find the LCD displays which are in the network..we are havin g many displays but we are not having any assets for that

[Hemoco]

Just link tblMonitor to tblComputers.

Example:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblMonitor.MonitorID, tblMonitor.MonitorModel,
tblMonitor.SerialNumber, tblMonitor.MonitorManufacturer,
tblMonitor.ManufacturedDate, tblMonitor.LastChanged
From tblComputers Inner Join
tblMonitor On tblComputers.Computername = tblMonitor.Computername

[Srikanth08]

is there any report or query for that..

[Hemoco]

If the monitor is connected to a computer it's in table "tblmonitor"

[Srikanth08]

Awaiting Reply..