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 c.name as CaseName
    , p.PrincipalLogin as DomainUser
    , tp.name 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
--WHERE c.Name = 'CASENAME'
GROUP BY c.name, p.PrincipalLogin, tp.name, 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.

https://www-secure.symantec.com/connect/articles/c...

https://www-secure.symantec.com/connect/articles/c...

SOLUTION