→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
lbarron
Engaged Sweeper
Hi

I'm wanting to create a report which shows me a list of assets grouped by the chassis type i.e. small form factor, tower etc. I know this summary is already shown on one of the screens but I'd like a complete list of assets and the operating system which they are running.

Does anyone know which table the chassis type is in?

Thanks

Lee
1 ACCEPTED SOLUTION
RCorbeil
Honored Sweeper II
lbarron wrote:
Does anyone know which table the chassis type is in?

SELECT
...
tSysChassisTypes.ChassisName,
...
FROM
tblAssets
...
INNER JOIN tblSystemEnclosure ON tblSystemEnclosure.AssetID = tblAssets.AssetID
INNER JOIN tSysChassisTypes ON tSysChassisTypes.ChassisType = tblSystemEnclosure.ChassisTypes
WHERE
tSysChassisTypes.ChassisName <> 'Docking Station'
...

does the job for me.

Note that there are a variety of chassis type names used for notebook computers -- notebook, laptop, portable, etc.

View solution in original post

1 REPLY 1
RCorbeil
Honored Sweeper II
lbarron wrote:
Does anyone know which table the chassis type is in?

SELECT
...
tSysChassisTypes.ChassisName,
...
FROM
tblAssets
...
INNER JOIN tblSystemEnclosure ON tblSystemEnclosure.AssetID = tblAssets.AssetID
INNER JOIN tSysChassisTypes ON tSysChassisTypes.ChassisType = tblSystemEnclosure.ChassisTypes
WHERE
tSysChassisTypes.ChassisName <> 'Docking Station'
...

does the job for me.

Note that there are a variety of chassis type names used for notebook computers -- notebook, laptop, portable, etc.