
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-16-2015 07:30 PM
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
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
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-17-2015 02:15 PM
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
5 REPLIES 5

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-20-2016 02:37 PM
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.
One without resolution and one with. Some don't even have any resolution on them at all.
Very strange.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-17-2015 02:46 PM
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?

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-19-2015 11:30 AM
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.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-17-2015 02:19 PM
Thank you Daniel.B!

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-17-2015 02:15 PM
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
