Hardware Inventory with Dept,Username,ComputerName

[sundarrs]

Hi,

I need to generate a inventory with details like

ComputerName,Username,Department Name,Machine model,Laptop or Desktop

Best Regards,

Sundar RS

[Hemoco]

Please try the following report:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblADusers.Username, tblADusers.Department,
tblComputersystem.Model, TsysChassisTypes.ChassisName
From tblComputers Inner Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain Left Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Left Join
tblSystemEnclosure On tblComputers.Computername =
tblSystemEnclosure.Computername Inner Join
TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Order By tblComputers.ComputerUnique