New Report

[lbarron]

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

[RCorbeil · Accepted solution]

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.