monitor report

[Dtyner]

Hello,

I was wondering if there was a way to run the monitor report but add a column to show what resolution the monitor is.

Dominic

[TekTok]

I pasted in this same report, but I am getting duplicate records.
One without resolution and one with. Some don't even have any resolution on them at all.

Very strange.

[LJayP]

Is there anyway to show this next the monitor on the asset page? Where it shows the connected monitors I would like next to it show the resolution or is this not possible?

[Daniel_B]

LJayP wrote:
Is there anyway to show this next the monitor on the asset page? Where it shows the connected monitors I would like next to it show the resolution or is this not possible?

Modifying web console pages is not supported. In order to have an overview according to your needs, use a custom report.

[Dtyner]

Thank you Daniel.B!

[Daniel_B · Accepted solution]

The monitor does not give us a resolution as this is being defined by your video controller. You could add tblVideoController to your report and let it display the current resolution:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysOS.OSname,
  tsysOS.Image As icon,
  tblMonitor.MonitorManufacturer As Manufacturer,
  tblMonitor.MonitorModel,
  tblMonitor.SerialNumber,
  tblMonitor.ManufacturedDate,
  tblVideoController.CurrentHorizontalResolution,
  tblVideoController.CurrentVerticalResolution
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 Join tblVideoController On tblAssets.AssetID = tblVideoController.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName