cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
woookash
Engaged Sweeper
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
4 REPLIES 4
Hemoco
Lansweeper Alumni
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
Engaged Sweeper
And one more detail: how do I remove the "non-active" computers from this report?
woookash
Engaged Sweeper
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
Lansweeper Alumni
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.