Get an audit of Monitor Information from Your Environment
Discover all monitors within your network along with details information like model, manufacturer, serial number, date of manufacturing and more. This overview also lists the asset to which the monitors are connected so you can quickly navigate to the computer as well. Get all the details in one overview.
Monitor Information Query
Select Top (1000000) tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblMonitor.MonitorManufacturer As [Manufacturer Monitor],
tblMonitor.MonitorModel,
tblMonitor.SerialNumber,
tblMonitor.ManufacturedDate,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Firstseen As [Created at],
tblAssets.Lastseen As [Last successful scan],
tblExtendedDisplayUni.SizeInInch,
tblExtendedDisplayUni.MaxResolution,
tblExtendedDisplayUni.AspectRatio,
tblExtendedDisplayUni.ResponseTimeInMs,
tblExtendedDisplayUni.HDType,
tblExtendedDisplayUni.DisplayTech,
tblExtendedDisplayUni.RefreshRate,
tblExtendedDisplayUni.Panel,
tblExtendedDisplayUni.HeightinCm,
tblExtendedDisplayUni.WidthInCm,
tblExtendedDisplayUni.DiagonalInCm,
tblExtendedDisplayUni.HasSpeakers,
tblExtendedDisplayUni.HasCamera,
tblExtendedDisplayUni.HasUsbHub,
tblExtendedDisplayUni.UsbUpstream,
tblExtendedDisplayUni.NrOfUsbUpstream,
tblExtendedDisplayUni.UsbTypeADownstream,
tblExtendedDisplayUni.NrOfVGA,
tblExtendedDisplayUni.NrOfDVI,
tblExtendedDisplayUni.NrOfHdmi,
tblExtendedDisplayUni.HDMIVersion,
tblExtendedDisplayUni.NumberOfDisplayPorts,
tblExtendedDisplayUni.DisplayPortVersion,
tblExtendedDisplayUni.EnergyClass,
tblExtendedDisplayUni.SDRPer1000u,
tblExtendedDisplayUni.AverageWattUsage,
tblExtendedDisplayUni.StandByWattUsage,
tblExtendedDisplayUni.MaxWattUsage,
tblExtendedDisplayUni.WattUsageWhenOff,
tblExtendedDisplayUni.WattPowerSave,
tblExtendedDisplayUni.ACVoltage,
tblExtendedDisplayUni.ACFreqInHz,
tblExtendedDisplayUni.CurrentInA,
tblExtendedDisplayUni.CreationDate
From tblAssets
Inner Join tblMonitor On tblMonitor.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Outer Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Left Outer Join tblExtendedDisplayUni On
tblExtendedDisplayUni.ExtendedDisplayUniId =
(Select tblAssetCustom.ExtendedDisplayUniId
From tblAssetCustom Join tblAssets On tblAssets.AssetID =
tblAssetCustom.AssetID
Where tblAssets.AssetUnique = 'Mon:' + tblMonitor.MonitorManufacturer +
':' + tblMonitor.SerialNumber)
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName
