Screen resolutions report

[ifm]

Is there a Lansweeper resolution report that will show me all the different screen resolutions used and the number of computers for each resolution?

[ifm]

Exactly like that, thank you!

[Hemoco · Accepted solution]

Something like this?

Select Top 1000000 Coalesce(Cast(tblVideoController.CurrentHorizontalResolution
As nvarchar), 'unknown') As Horizontal,
Coalesce(Cast(tblVideoController.CurrentVerticalResolution As nvarchar),
'unknown') As Vertical,
Count(tblAssets.AssetID) As Counted
From tblVideoController
Inner Join tblAssets On tblVideoController.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1
Group By Coalesce(Cast(tblVideoController.CurrentHorizontalResolution As
nvarchar), 'unknown'),
Coalesce(Cast(tblVideoController.CurrentVerticalResolution As nvarchar),
'unknown')
Order By Horizontal Desc,
Vertical Desc

[ifm]

Thank you!
That generate a list with one line for each resoluton. Is it possible to get a list like this instead?

1024x768 45
1280x1024 62
1366x768 48

and so on...

[Hemoco]

Please try this:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tsysOS.OSname,
Coalesce(Cast(tblVideoController.CurrentHorizontalResolution As nvarchar),
'unknown') As Horizontal,
Coalesce(Cast(tblVideoController.CurrentVerticalResolution As nvarchar),
'unknown') As Vertical,
tsysOS.Image As icon
From tblVideoController
Inner Join tblAssets On tblVideoController.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1
Order By Horizontal Desc,
Vertical Desc