
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2012 08:14 PM
I am a non-technical novice and would really like some help! Can anyone tell me how (if possible!) to create a report to collect the following data to create an asset register:
1)Computer Name
2)Vendor
3)Model
4)Serial Number
5)CPU
6)Speed
7)Memory
8)Hard disk size
9)Operating system (including SP)
10)IP address
11) Last Known user
12) Last seen
13) First seen
If it needs to be done in two or more reports I don't mind that as I'll use Excel to join them so long as either the Serial Number or Computer name is in all reports as a "key".
Am I expecting too much from Lansweeper?!?!
Thank you. 🙂
1)Computer Name
2)Vendor
3)Model
4)Serial Number
5)CPU
6)Speed
7)Memory
8)Hard disk size
9)Operating system (including SP)
10)IP address
11) Last Known user
12) Last seen
13) First seen
If it needs to be done in two or more reports I don't mind that as I'll use Excel to join them so long as either the Serial Number or Computer name is in all reports as a "key".
Am I expecting too much from Lansweeper?!?!
Thank you. 🙂
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-29-2012 06:22 PM
Please try the report below.
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.
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputersystem.Manufacturer, tblComputersystem.Model,
tblComputerSystemProduct.IdentifyingNumber, web40ProcessorCapacity.CPU,
web40ProcessorCapacity.Name, web40ProcessorCapacity.MaxClockSpeed,
web40ProcessorCapacity.NrOfProcessors, web40CorrectMemory.Memory,
Cast(Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As
numeric) As varchar) As [Disk Size], Web40OSName.OSname, Web40OSName.SP,
tblComputers.LastknownIP, tblComputers.Username, tblComputers.Userdomain,
tblComputers.Lastseen, tblComputers.Firstseen
From tblComputers 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 Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Where tblDiskdrives.Caption Like '%c%'
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.
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-31-2012 02:53 PM
Thank you so much. This is great!

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-29-2012 06:22 PM
Please try the report below.
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.
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputersystem.Manufacturer, tblComputersystem.Model,
tblComputerSystemProduct.IdentifyingNumber, web40ProcessorCapacity.CPU,
web40ProcessorCapacity.Name, web40ProcessorCapacity.MaxClockSpeed,
web40ProcessorCapacity.NrOfProcessors, web40CorrectMemory.Memory,
Cast(Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As
numeric) As varchar) As [Disk Size], Web40OSName.OSname, Web40OSName.SP,
tblComputers.LastknownIP, tblComputers.Username, tblComputers.Userdomain,
tblComputers.Lastseen, tblComputers.Firstseen
From tblComputers 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 Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Where tblDiskdrives.Caption Like '%c%'
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.
