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. With rising power costs and the possibility to save costs by using more eco-friendly technologies, getting an overview of the least energy-efficient monitors in your IT estate can be a big help in planning your asset lifecycle. You can find more info on this report in the Monitor Monitors Pro Tips blog post.
The report below lists all monitors where the Average Watt Usage is higher than 20 Watts.
You can adjust the Average Watt Usage filter by adjusting “Where tblExtendedDisplayUni.AverageWattUsage > 20” in the code below with the desired value.
Monitor Power Consumption Query
Select Top (1000000) tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblMonitor.MonitorManufacturer As [Manufacturer Monitor],
tblMonitor.MonitorModel,
tblMonitor.SerialNumber,
tblExtendedDisplayUni.AverageWattUsage,
tblExtendedDisplayUni.StandByWattUsage,
tblExtendedDisplayUni.MaxWattUsage,
tblMonitor.ManufacturedDate,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
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.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.AverageWattUsage > 20 And tblAssetCustom.State = 1
Order By tblExtendedDisplayUni.AverageWattUsage Desc,
tblAssets.AssetName
