Report To Help With Inventory

[mattgbarnes]

Hello,

We're currently doing a hardware inventory and need the following info in one report. Can someone please tell me how to accomplish this?

PC Name
IP address
Last User
Computer Model
Computer Serial
Processor
Memory Installed
Windows Version

Thanks!
Matt

[Hemoco · Accepted solution]

Please use the report below for the information you are after.

Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, tblComputers.LastknownIP As IP, tblComputers.Username, tblComputers.Userdomain, tblComputersystem.Manufacturer, tblComputersystem.Model, tblComputerSystemProduct.IdentifyingNumber As AssetTag, web40ProcessorCapacity.CPU, web40CorrectMemory.Memory, Web40OSName.OSname As OS, tblOperatingsystem.Caption As FullOSName, Web40OSName.SP, Web40OSName.OScode From tblComputers Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join tblComputersystem On tblComputers.Computername = tblComputersystem.Computername Left Join tblComputerSystemProduct On tblComputers.Computername = tblComputerSystemProduct.Computername Left Join web40ProcessorCapacity On web40ProcessorCapacity.Computername = tblComputers.Computername Left Join web40CorrectMemory On web40CorrectMemory.Computername = tblComputers.Computername Inner 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.