Jetzt Ausprobieren

Monitor DisplayPort Audit

Hardware

List All Monitors That Have a DisplayPort Port

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. DisplayPort is already the standard for most monitor connections, so knowing exactly which monitors have which connectivity options can help greatly in planning your asset lifecycle and prioritizing upgrades. You can find more info on this report in the Monitor Monitors Pro Tips blog post. The report below lists all monitors that have a DisplayPort Port along with the DisplayPort version and all the other monitor details. Monitor power consumption report  

Monitor DisplayPort 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

Show

Hide