Video Screencast Help

DA Audit Trail?

Created: 22 Jun 2012 • Updated: 06 Jul 2012 | 1 comment
patriot3w's picture
This issue has been solved. See solution.

Is Audit Trail available in DA? For example, I changed the role and permissions, is it logged?

Thank you.

Comments 1 CommentJump to latest comment

TonySterling's picture

Permissions are logged in the table tblHistCasePermission.

You could use a query like this to see what permissions where added then removed.

SELECT as CaseName
    , p.PrincipalLogin as DomainUser
    , as PermissionName
    , hc.startdate as StartDate
    , hc.enddate as EndDate
FROM tblHistCasePermission hc
JOIN tblPrincipal p on p.PrincipalID = hc.PrincipalID
JOIN tblPermission tp on tp.PermissionID = hc.PermissionID
JOIN tblCase c on c.CaseID = hc.CaseID
GROUP BY, p.PrincipalLogin,, hc.StartDate, hc.EndDate

You can change the WHERE clause to only run it on a specific case.

Then you could use these articles and create your own SQL Report.