Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-31-2012 11:58 AM
Hi,
we need a report that contains all vendors, models,serialnumber, installed OS, domain and hostname. The list should contain all computers host-by-host
could you post the query please
we need a report that contains all vendors, models,serialnumber, installed OS, domain and hostname. The list should contain all computers host-by-host
could you post the query please
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
10-31-2012 02:12 PM
Please use the report below for the information you are after.
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. The report will also be listed in the Lansweeper web console under "All available reports".
Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, Web40OSName.OSname As OS, tblOperatingsystem.Caption As FullOSName, tblComputersystem.Manufacturer As Vendor, tblComputersystem.Model, tblComputerSystemProduct.IdentifyingNumber As AssetTag From tblComputers Left Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Left Join tblComputersystem On tblComputers.Computername = tblComputersystem.Computername Left Join tblComputerSystemProduct On tblComputers.Computername = tblComputerSystemProduct.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. The report will also be listed in the Lansweeper web console under "All available reports".
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-31-2012 02:12 PM
Please use the report below for the information you are after.
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. The report will also be listed in the Lansweeper web console under "All available reports".
Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, Web40OSName.OSname As OS, tblOperatingsystem.Caption As FullOSName, tblComputersystem.Manufacturer As Vendor, tblComputersystem.Model, tblComputerSystemProduct.IdentifyingNumber As AssetTag From tblComputers Left Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Left Join tblComputersystem On tblComputers.Computername = tblComputersystem.Computername Left Join tblComputerSystemProduct On tblComputers.Computername = tblComputerSystemProduct.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. The report will also be listed in the Lansweeper web console under "All available reports".
