Docusign Insight - How to create Monthly User Access Report

A monthly user access report can be created with a Sisense report.

The following SQL will copy what is displayed in the UI to CSV. This needs to run against the Seal database.

 

1. Create target directory before execution. For example, c:\sealout

2. Execute the following query against the Seal database:

(select a.identifier as "Identifier", a.created as "Time", s.display_name as "User", a.operation as "Operation", a.client_ip as "IP", a.status as "Status", a.parameters as "Parameters"
from audit_log a
join seal_user s on a.user_id = s.id
where a.created between '2018-03-01' and '2018-03-31'
order by a.created desc)

3. Copy the results to 'c:\sealout\user_audit.csv' (delimiter '|', HEADER, format CSV);

Please note to change the date parameters underlined above to fit your requirements.

 

NOTE *** If you wish to filter root users, service accounts, seal-software, and Docusign users, run the following query instead.

(select a.identifier as "Identifier", a.created as "Time", s.display_name as "User", a.operation as "Operation", a.client_ip as "IP", a.status as "Status", a.parameters as "Parameters"
from audit_log a
join seal_user s on a.user_id = s.id

where

s.username not like 'root'

and s.username not like '%@seal-software.com'

and s.email not like '%@seal-software.com'

and s.email not like '%@company.com'

and s.email not like '%@docusign.com'

a.created between '2018-03-01' and '2018-03-31'
order by a.created desc)