cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Susan_A
Lansweeper Alumni
The report below returns a log of who made changes to assets or Lansweeper settings and when. This report only works in Lansweeper 6.0 or a more recent Lansweeper release, as tracking of configuration changes was first added to Lansweeper 6.0. More information on this feature can be found in this knowledge base article. If you haven't already, you can update your Lansweeper installation to version 6.0 by following these instructions.
This report was added as a built-in report in version 6.0.100.
Select Top 1000000 tblConfigLog.Date,
Case tblConfigLog.ActionID When 1 Then 'change' When 2 Then '+'
When 3 Then '-' End As Action,
tblConfigLog.Description,
tblConfigLog.OldValue,
tblConfigLog.NewValue,
tblConfigLog.displayname As ChangeMadeBy,
htblusers.username,
htblusers.userdomain,
htblusers.name,
htblusers.email,
htblusers.mobile,
htblusers.telephone
From tblConfigLog
Left Join htblusers On htblusers.userid = tblConfigLog.UserID
Order By tblConfigLog.Date Desc
5 REPLIES 5
hakan35
Engaged Sweeper
possible to extend this Report also with executed Actions from Asset Managers, like Reboot/Shutdown ect.. ?
or would it be another report then ?

th@nks
marrngtn
Engaged Sweeper III
Awesome capability!!!
Vancealot
Engaged Sweeper
Is there a way to list the IP that was used when the change was made?
Susan_A
Lansweeper Alumni
If you haven't already, update to Lansweeper 6.0 by following these instructions. As mentioned in my initial post, tracking of configuration changes was only added in 6.0, so this report will only work in 6.0 and future Lansweeper releases. The tblConfigLog table doesn't exist in Lansweeper 5.x releases.
matt
Engaged Sweeper
Nice I've been looking for something like this. Although getting some query errors with tblConfigLog being an Unknown object name.