→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Dtyner
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

5 REPLIES 5
TekTok
Engaged Sweeper II
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
Engaged Sweeper III
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
Lansweeper Alumni
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
Engaged Sweeper II
Thank you Daniel.B!
Daniel_B
Lansweeper Alumni
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