new report laptops and notebooks

[ChrisLongVCSC56]

I need some assistance on creating a report that contains laptops and notebooks. Has anyone created this report?

Thank You

[Lekius · Accepted solution]

Hello!

You can refet to the chassis types as follow : 

Laptops : 

Select Top 1000000 tblassets.AssetName,
  tblassets.FQDN,
  tblADusers.Displayname,
  tblassets.Domain,
  tsysIPLocations.IPLocation,
  tblassets.IPAddress,
  tblassets.Mac,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber,
  tblOperatingsystem.Caption,
  tblassets.Firstseen,
  tblassets.Lastseen,
  TsysChassisTypes.Chassistype
From tblassets
  Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
  Left Join tblOperatingsystem On tblassets.AssetID = tblOperatingsystem.AssetID
  Inner Join tblAssetCustom On tblassets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
      tblassets.LocationID
  Inner Join tblSystemEnclosure On
      tblassets.AssetID = tblSystemEnclosure.AssetID
  Inner Join TsysChassisTypes On tblSystemEnclosure.ChassisTypes =
      TsysChassisTypes.Chassistype
  Left Join tblADusers On tblassets.Username = tblADusers.Username
Where tblAssetCustom.Manufacturer Not In ('Amazon', 'Amazon EC2', 'VMware', 'VMWare, Inc.', 'Xen')
  And tblOperatingsystem.Caption Not Like '%Server%' And tblassets.Lastseen >=
  DateAdd(day, -60, GetDate()) And TsysChassisTypes.Chassistype In ('8', '9',
  '10', '14', '11', '12', '18', '21', '30', '31', '32') And
  tsysassettypes.AssetTypename = 'Windows' And tblAssetCustom.State = 1
Order By tsysassettypes.AssetTypename,
  tblassets.AssetName

Desktops :

Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypeIcon10 As icon,
tsysIPLocations.IPLocation,
tblassets.IPAddress,
tblassets.Mac,
tblassetcustom.Serialnumber,
tblassetcustom.Manufacturer,
tblassetcustom.Model,
tblOperatingsystem.Caption,
tblassets.Lastseen,
tblassets.Lasttried
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblassets.LocationID
Inner Join tblOperatingsystem On
tblassets.AssetID = tblOperatingsystem.AssetID
Inner Join tblSystemEnclosure On
tblassets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Where tblassetcustom.Manufacturer Not In ('Amazon', 'Amazon EC2', 'VMware', 'VMWare, Inc.', 'Xen')
And tblOperatingsystem.Caption Not Like '%Server%' And tblassets.Lastseen >=
DateAdd(day, -60, GetDate()) And TsysChassisTypes.Chassistype In ('1', '3',
'7', '5', '6', '15', '16', '34', '35', '36', '4', '13') And
tsysassettypes.AssetTypename = 'Windows' And tblassetcustom.State = 1
Order By tblassets.AssetName

 Feel free to adjust as needed. Laptop includes Tablets, and it also filters Server OS

Hope this helps