Reports: Chassis type

[sbekeme]

Hi,

i want to create a report witch includes the chassis type of the computer. So far i have only found that the chassis types are defines in dbo.TsysChassisTypes. but where can i find the the link between that table and the computers?

Regards
Kevin

[sbekeme]

tblsystemenclosure nice.

thx for the help

[Hemoco]

Example:

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