REPORTS: I need LAST uSER in my report for hardware specs per computer

[LanTheSweeper]

Hi
I created the following report to know what computer model from what vendor are in use with how much total memory per machine.
Thats fine and working, now I need to get this joint to LAST USER. Is there any way to see the existing joints to each table, just like as a table chart of all tables in LanSweeper?

Here my code for maybe useful others:

Select Top 1000000
tblComputers.Computername,
Floor(Cast(Cast(tblComputersystem.TotalPhysicalMemory As bigint) / 1024 / 1024 As numeric)) As TMG,
tblComputerSystemProduct.Vendor,
tblComputerSystemProduct.Name,
tblComputersystem.TotalPhysicalMemory As MG
From tblComputers Inner Join tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername

Thanks a lot in advance

Cheers

Michael

[LanTheSweeper]

Thanks a lot I found the solution by my self 😉

But you doing a great support...

Thanks

Michael

[Hemoco]

Select Top 1000000 tblComputers.Computername,
Floor(Cast(Cast(tblComputersystem.TotalPhysicalMemory As bigint) / 1024 /
1024 As numeric)) As TMG, tblComputerSystemProduct.Vendor,
tblComputerSystemProduct.Name, tblComputersystem.TotalPhysicalMemory As MG,
tblComputers.Userdomain, tblComputers.Username, tblADusers.Displayname
From tblComputers Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Left Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain

[LanTheSweeper]

Hi Support

Thanks at first for this quick response 😉
But I need something where I can see the First Name and Lastname.
I thought I could use the table tblADusers and column username and Inner join it with tblComputers and column username.

But there is no possibility to join...

Any idea ?

Thanks a lot in advance

Michael

[Hemoco]

You don't need an extra table or join:

Select Top 1000000 tblComputers.Computername,
Floor(Cast(Cast(tblComputersystem.TotalPhysicalMemory As bigint) / 1024 /
1024 As numeric)) As TMG, tblComputerSystemProduct.Vendor,
tblComputerSystemProduct.Name, tblComputersystem.TotalPhysicalMemory As MG,
tblComputers.Userdomain, tblComputers.Username
From tblComputers Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername