→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎04-19-2016 11:35 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
‎06-01-2017 10:52 AM
‎08-25-2016 04:53 AM
‎07-19-2016 09:56 PM
‎04-24-2016 02:57 AM
‎04-21-2016 07:22 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now