Detailed Report for HW and Users

[kevinoie]

Any help on this would be greatly appreciated. Im running a report for a detailed breakdown on hardware which gives me all the info i need on the PC's etc... However I need to add the user dept into the report. When I add the Dept field from dbo.tblADusers.Department the report hangs on me and the program stopps working.. below is the full code for the Hardware report. I would be eternally grateful if you could let me know how to add the user dept into this report. Many Thanks.

Select Top 1000000 tblComputers.Computer, tblComputerSystemProduct.Vendor As Manufacturer, tblComputerSystemProduct.Name As Model, TsysChassisTypes.ChassisName, Web40OSName.OSname, Web40OSName.SP, web40ProcessorCapacity.CPU, web40ProcessorCapacity.NrOfProcessors, web40CorrectMemory.Memory, tblComputers.LastknownIP, tblOperatingsystem.InstallDate, tblComputers.Username, tblComputers.Lastseen From tblComputers Inner Join web40CorrectMemory On web40CorrectMemory.Computername = tblComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join tblComputerSystemProduct On tblComputers.Computername = tblComputerSystemProduct.Computername Inner Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Inner Join web40ProcessorCapacity On web40ProcessorCapacity.Computername = tblComputers.Computername Inner Join tblSystemEnclosure On tblSystemEnclosure.Computername = tblComputers.Computername Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype = tblSystemEnclosure.ChassisTypes Order By tblComputers.Computer

[kevinoie]

Thats exactly what I need. Thanks a million.. Very much appreciated.. Kevin.

[Hemoco · Accepted solution]

Select Top 1000000 tblComputers.Computer, tblComputerSystemProduct.Vendor As
Manufacturer, tblComputerSystemProduct.Name As Model,
TsysChassisTypes.ChassisName, Web40OSName.OSname, Web40OSName.SP,
web40ProcessorCapacity.CPU, web40ProcessorCapacity.NrOfProcessors,
web40CorrectMemory.Memory, tblComputers.LastknownIP,
tblOperatingsystem.InstallDate, tblComputers.Username, tblComputers.Lastseen,
tblADusers.Department
From tblComputers Inner Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
web40ProcessorCapacity On web40ProcessorCapacity.Computername =
tblComputers.Computername Inner Join
tblSystemEnclosure On tblSystemEnclosure.Computername =
tblComputers.Computername Inner Join
TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes Left Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain
Order By tblComputers.Computer