Forum Discussion

patriot3w's avatar
patriot3w
Level 5
13 years ago
Solved

DA Audit Trail?

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

Thank you.

  • 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/creating-custom-report-symantec-enterprise-vault-discovery-accelerator-80-and-higher-part-1

    https://www-secure.symantec.com/connect/articles/creating-custom-report-symantec-enterprise-vault-discovery-accelerator-80-and-higher-part-2

1 Reply

Replies have been turned off for this discussion
  • 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/creating-custom-report-symantec-enterprise-vault-discovery-accelerator-80-and-higher-part-1

    https://www-secure.symantec.com/connect/articles/creating-custom-report-symantec-enterprise-vault-discovery-accelerator-80-and-higher-part-2