Hi,
I have "Administrator+Agent" permissions,
What other additional permissions needed to view the report? Where to place them?
Code report
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.name,
htblusers.username,
htblusers.userdomain,
htblusers.email,
htblusers.telephone,
htblusers.mobile
From tblConfigLog
Left Join htblusers On htblusers.userid = tblConfigLog.UserID
Order By tblConfigLog.Date Desc