cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ifm
Champion Sweeper
Is there a Lansweeper resolution report that will show me all the different screen resolutions used and the number of computers for each resolution?
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

4 REPLIES 4
ifm
Champion Sweeper
Exactly like that, thank you!
Hemoco
Lansweeper Alumni
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
Champion Sweeper
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
Lansweeper Alumni
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