List of who made changes to assets or settings and when

[Susan_A]

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

[hakan35]

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]

Awesome capability!!!

[Vancealot]

Is there a way to list the IP that was used when the change was made?

[Susan_A]

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]

Nice I've been looking for something like this. Although getting some query errors with tblConfigLog being an Unknown object name.