Report Laptops

[cygategbg]

Hi, is there a report option to get a list of all laptops and one for "not laptops"

[Hemoco]

1) laptops

Select tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Domain, TsysChassisTypes.ChassisName
From tblComputers Inner Join
  tblSystemEnclosure On tblComputers.Computername =
    tblSystemEnclosure.Computername Inner Join
  TsysChassisTypes On TsysChassisTypes.Chassistype =
    tblSystemEnclosure.ChassisTypes
Where (tblSystemEnclosure.ChassisTypes = 8 Or tblSystemEnclosure.ChassisTypes =
    9 Or tblSystemEnclosure.ChassisTypes = 10)

2) non-laptops

Select tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Domain, TsysChassisTypes.ChassisName
From tblComputers Inner Join
  tblSystemEnclosure On tblComputers.Computername =
    tblSystemEnclosure.Computername Inner Join
  TsysChassisTypes On TsysChassisTypes.Chassistype =
    tblSystemEnclosure.ChassisTypes
Where Not tblSystemEnclosure.ChassisTypes = 8 And
  Not tblSystemEnclosure.ChassisTypes = 9 And
  Not tblSystemEnclosure.ChassisTypes = 10