Audit – Monitor Size

List All Monitors Smaller Than 27 Inch

Lansweeper automatically scans monitors connected to devices along with the display panel details, features, connectivity options, power consumption details, and what asset they are connected to. As technology improves and becomes more affordable, monitor sizes of 27 inches are starting to become the next standard. To get an overview of all your monitors that don’t meet your standard yet and should be next to be on the replacement/upgrade list, you can use the overview below. You can find more info on this report in the Monitor Monitors Pro Tips blog post. The report below lists all monitors in your IT environment that are smaller than 27 inches.

You can adjust the size filter by adjusting „Where tblExtendedDisplayUni.SizeInInch < 27“ in the code below with the desired value for your standard.

Monitor Size Query

Select Top (1000000) tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblMonitor.MonitorManufacturer As [Manufacturer Monitor],
tblMonitor.MonitorModel,
tblMonitor.SerialNumber,
tblExtendedDisplayUni.SizeInInch,
tblExtendedDisplayUni.MaxResolution,
tblMonitor.ManufacturedDate,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
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,
tblAssets.Firstseen As [Created at],
tblAssets.Lastseen As [Last successful scan]
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 tblExtendedDisplayUni.SizeInInch < 27 and tblAssetCustom.State = 1
Order By tblAssets.AssetName

Show

Hide