→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎06-16-2015 07:30 PM
Solved! Go to Solution.
‎06-17-2015 02:15 PM
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
‎12-20-2016 02:37 PM
‎06-17-2015 02:46 PM
‎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?
‎06-17-2015 02:19 PM
‎06-17-2015 02:15 PM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now