Laptops only

[Eichelberger]

Is there a way to only show laptops on this report? I'm using version 5.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.AssetName,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.IPAddress As IP,
tblAssets.Lastseen
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID Where (tblSoftwareUni.softwareName Like '%Sophos%') Or
(tblSoftwareUni.softwareName Like '%Guardian Edge%') Or
(tblSoftwareUni.softwareName Like '%Symantec Endpoint Encryption%')) And
tblAssets.Lastseen <> '' And tblAssets.Assettype = -1
Order By tblAssets.AssetUnique

[Eichelberger]

That was perfect. Can you do the same for desktops? Thank you.

[Hemoco]

Eichelberger wrote:
That was perfect. Can you do the same for desktops? Thank you.

It really depends on what you consider "desktops". Below is a list of available chassis types. In the report we provided, we selected 8 (portable), 9 (laptop) and 10 (notebook). To select your own chassis types, replace what we've marked in bold.

Where (tblSoftwareUni.softwareName Like '%Sophos%') Or
(tblSoftwareUni.softwareName Like '%Guardian Edge%') Or
(tblSoftwareUni.softwareName Like '%Symantec Endpoint Encryption%')) And
tblAssets.Lastseen <> '' And (TsysChassisTypes.Chassistype = 8 Or
TsysChassisTypes.Chassistype = 9 Or TsysChassisTypes.Chassistype = 10) And
tblAssets.Assettype = -1

1
Other
2
Unknown
3
Desktop
4
Low Profile Desktop
5
Pizza Box
6
Mini Tower
7
Tower
8
Portable
9
Laptop
10
Notebook
11
Hand Held
12
Docking Station
13
All in One
14
Sub Notebook
15
Space-Saving
16
Lunch Box
17
Main System Chassis
18
Expansion Chassis
19
Sub Chassis
20
Bus Expansion Chassis
21
Peripheral Chassis
22
Storage Chassis
23
Rack Mount Chassis
24
Sealed-Case PC

[Hemoco · Accepted solution]

Try:

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.AssetName,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
TsysChassisTypes.ChassisName,
tblAssets.IPAddress As IP,
tblAssets.Lastseen
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID Where (tblSoftwareUni.softwareName Like '%Sophos%') Or
(tblSoftwareUni.softwareName Like '%Guardian Edge%') Or
(tblSoftwareUni.softwareName Like '%Symantec Endpoint Encryption%')) And
tblAssets.Lastseen <> '' And (TsysChassisTypes.Chassistype = 8 Or
TsysChassisTypes.Chassistype = 9 Or TsysChassisTypes.Chassistype = 10) And
tblAssets.Assettype = -1
Order By tblAssets.AssetUnique