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
