‎08-08-2017 04:17 PM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now