‎06-22-2016 03:25 PM
‎08-26-2016 07:07 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Displayname,
Case tblConfigLog.ActionID When 1 Then 'change' When 2 Then '+'
When 3 Then '-' End As Action,
tblConfigLog.Description,
tblConfigLog.Date
From tblConfigLog
Left Join tblAssets
On tblAssets.AssetName = (SubString(tblConfigLog.Description,
CharIndex('''', tblConfigLog.Description, 1) + 1,
(Len(tblConfigLog.Description) - CharIndex('''',
Reverse(tblConfigLog.Description), 1)) - (CharIndex('''',
tblConfigLog.Description, 1))))
Left Join tblADusers On tblADusers.Userdomain + '\' + tblADusers.Username =
tblConfigLog.displayname
Where tblConfigLog.Description Like '%Asset%' And tblConfigLog.Date >
GetDate() - 30
Order By tblConfigLog.Date Desc
‎06-22-2016 04:48 PM
‎06-22-2016 04:25 PM
Select Top 1000000 tblConfigLog.Date,
tblConfigLog.displayname As ChangeMadeBy,
htblusers.name,
Case tblConfigLog.ActionID When 1 Then 'change' When 2 Then '+'
When 3 Then '-' End As Action,
tblConfigLog.Description,
tblConfigLog.OldValue,
tblConfigLog.NewValue,
htblusers.username,
htblusers.userdomain,
htblusers.email,
htblusers.telephone
From tblConfigLog
Left Join htblusers On htblusers.userid = tblConfigLog.UserID
Where tblConfigLog.Date > GetDate() - 30
Order By tblConfigLog.Date Desc
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now