Users: Changes made to Lansweeper configuration (Built-in)

[Nick_VDB]

Added in v.6.0.100

The report below lists the changes that have been made in Lansweeper to assets or configuration per user.

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