cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Marco_Sola
Engaged Sweeper
Hi to everybody,

it is just me or in LS there is no information about size in inches of laptop?

Could someone suggest me the field, if any?

Or if not available, maybe consider this as a feature request.

Many thanks in advance
3 REPLIES 3
MakeBug
Champion Sweeper
I honestly don't think that it is possible to get this information.
Resolution sure, but size...you can't even find this information in the OS afaik.

Probably possible with a database Model = Size (but hell, who would create such a database?).
crashff
Champion Sweeper
Unfortunately, this doesn't work. The problem is that the PPI setting in windows doesn't account for pixel density. Default windows ppi setting is 96, but the screen may have a physical pixel density much higher (112 is common for HiDef screens) which throws off the report. Until they start embedding pixel density into the EDID information, it wont be possible with any reliability.

An good example is my HP Probook 450 G1 -it's actually 15.6", but this report thinks it's a 23".
Susan_A
Lansweeper Alumni
There's no specific field for monitor size in inches. We've added this to the wish list. Perhaps you could use a query like the one below to calculate the size based on the screen resolution and PPI values, which are scanned. Not sure how accurate this would be though.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
Ceiling(SqRt(Power((tblDesktopMonitor.ScreenWidth /
tblDesktopMonitor.PixelsPerXLogicalInch), 2) +
Power((tblDesktopMonitor.ScreenHeight /
tblDesktopMonitor.PixelsPerYLogicalInch), 2))) As MonitorSize
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblDesktopMonitor On tblDesktopMonitor.AssetID = tblAssets.AssetID
Where tblAssets.AssetID In (Select tblMonitor.AssetID
From tblMonitor) And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName