Computer report with specific extra infos

[woookash]

Hi,

I'm looking for a report that would give the following infos:

computername|manufacturer|model|dateofOSinstallation|lastloggedinuser

I was thinking of starting from the "computer model overview" view, but I'm unsure how to do that from there.

kr,

Lukasz

[Hemoco]

Please try the report below.
- TblComputers and tblADusers must be linked on both the Username and Userdomain fields.
- Add web40ActiveComputers to any report to include only active computers.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputersystem.Manufacturer, tblComputersystem.Model,
tblOperatingsystem.InstallDate, tblADusers.Displayname,
tblComputers.Userdomain
From tblComputers Left Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Left Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Left Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain Inner Join
web40ActiveComputers On web40ActiveComputers.Computername =
tblComputers.Computername
Order By tblComputers.ComputerUnique

[woookash]

And one more detail: how do I remove the "non-active" computers from this report?

[woookash]

Looks great!

One more question: we would like to have the full name of the user instead of the login. It has to be gathered from the tblADusers table (Displayname field).

I added "Left Join
tblADusers On tblComputers.Username = tblADusers.Username" but I'm missing how to avoid multiple entries (my god, my sql courses are SO far)

[Hemoco]

Please try the report below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputersystem.Manufacturer, tblComputersystem.Model,
tblOperatingsystem.InstallDate, tblComputers.Username, tblComputers.Userdomain
From tblComputers Left Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Left Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername
Order By tblComputers.ComputerUnique

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.