
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2012 04:04 PM
Hi,
we have just implemented Lansweeper and would like to start using some of the data we now have.
Is it possible to run a system wide report extracting individual information and then present this in a useful format.
For example, we are running a file server migration project where it would be very helpful to extract the mapped drive information for every computer into a format that can then be tinkered with in one large file.
the information in in the machine detail page, under windows - mapped drives.
Can anyone help with this ?
Phil
we have just implemented Lansweeper and would like to start using some of the data we now have.
Is it possible to run a system wide report extracting individual information and then present this in a useful format.
For example, we are running a file server migration project where it would be very helpful to extract the mapped drive information for every computer into a format that can then be tinkered with in one large file.
the information in in the machine detail page, under windows - mapped drives.
Can anyone help with this ?
Phil
Labels:
- Labels:
-
Archive
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2012 04:19 PM
For anyone else wondering: an example report for the requested information can be seen 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, tblmappeddrives.Username, tblmappeddrives.Driveletter,
tblmappeddrives.RemotePath, tblmappeddrives.Lastchanged
From tblComputers Inner Join
tblmappeddrives On tblComputers.Computername = tblmappeddrives.Computername
Order By tblComputers.ComputerUnique, tblmappeddrives.Driveletter
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.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2012 04:13 PM
Wow,
never mind, this was so simple to do it's almost funny.
the report builder is quite amazing.
thanks
Phil
never mind, this was so simple to do it's almost funny.
the report builder is quite amazing.
thanks
Phil
