How Can I Determine if a Computer is a Laptop or a Desktop Machine?

[lemr]

someone can tell me how can I determine if a computer is a laptop or a desktop Machine (using the tables of lansweeper)? thanks.

[RCorbeil]

Another approach is to LEFT JOIN to tblPortableBattery and check whether there's an entry in the table. If there is, it's a portable device (notebook).

Select Top 1000000
  tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  TsysChassisTypes.ChassisName As Chassis,
  Case
    When tblPortableBattery.AssetID Is Not Null
    Then 'Notebook'
    Else ''
  End As Class
From
  tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblSystemEnclosure On tblAssets.AssetID = tblSystemEnclosure.AssetID
  Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype = tblSystemEnclosure.ChassisTypes
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Left Join tblPortableBattery On tblAssets.AssetID = tblPortableBattery.AssetID
Where
  tblAssetCustom.State = 1
Order By
  tblAssets.Domain,
  tblAssets.AssetName

[Hemoco · Accepted solution]

The sample report below lists your Windows computers' chassis information. Note that there are several possible chassis values for "desktops" and "laptops", e.g. laptops can be identified as "laptop", "notebook" or "portable".

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
TsysChassisTypes.ChassisName As Chassis
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName

To use the report above, do the following:
• Open the report builder under Reports/Create New Report.
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.

P.S.: Please only create one thread for each question.