Standard Reference Tables & Views for the DropboxAccess Data Collector
The DropboxAccess Data Collector gathers essential user and group inventory information into standard reference tables. Unlike most of the other Access Analyzer data collectors, the DropboxAccess Data Collector writes data to these tables regardless of the job executing the query.
Dropbox Access Auditing Tables & Views
These tables and their associated views are outlined below:
| Table | Details |
|---|---|
| SA_Dropbox_DocumentMetadata | Contains one row per document collected and displays file details such as size and last time modified |
| SA_Dropbox_GroupMembers | Contains a unique row for each trustee per group and defines the access type of each member |
| SA_Dropbox_Groups | Contains all of the team-created groups and should have a unique row for each group |
| SA_Dropbox_Resources | Contains information about all audited resources, which can be files or folders. It should contain a unique row per resource. |
| SA_Dropbox_Rights | Contains all of the trustees who have access on shared folders and defines the access type |
| SA_Dropbox_SharedFolders | Contains all of the shared folders with corresponding OwnerID and access type along with the shared link policy |
| SA_Dropbox_TeamMembers | Contains one row per team member and displays information on members of any teams present |
| SA_Dropbox_Teams | Contains information on the teams within the Dropbox environment |
| SA_Dropbox_Trustees | Contains information about any trustee, group, or team that has been assigned permissions |
Views are the recommended way for you to obtain the information gathered by the DropboxAccess Data Collector. They contain additional information for building queries easily. The following is an explanation of the corresponding views created for some of the tables generated by the DropboxAccess Data Collector:
| Views | Details |
|---|---|
| SA_Dropbox_DocumentMetadataView | Displays the location and file details of all audited files |
| SA_Dropbox_GroupMembersView | Displays all of the team members, which groups they are members of, and access type on the group |
| SA_Dropbox_RightsView | Displays the rights applied to shared folders and the access type for the trustee |
| SA_Dropbox_SharedFoldersView | Displays shared folders, their owners, and whether the owner is a team member |
Dropbox Sensitive Data Discovery Auditing (SEEK) Tables & Views
These tables and their associated views are outlined below:
| Table | Details |
|---|---|
| SA_Dropbox_Criteria | Contains the sensitive data criteria which are selected for collection by the scan engine (data collector configuration) |
| SA_Dropbox_Matches | Contains rolled up aggregate counts of the sensitive data criteria matches found during the scan |
| SA_Dropbox_MatchHits | Contains the actual sensitive data discovered within files which matched selected criteria |
Views are the recommended way for you to obtain the information gathered by the DropboxAccess Data Collector. They contain additional information for building queries easily. The following is an explanation of the corresponding views created for some of the tables generated by the DropboxAccess Data Collector:
| Views | Details |
|---|---|
| SA_Dropbox_MatchesView | Surfaces all relevant data about the files, its location, and the type of criteria found |
| SA_Dropbox_MatchHitsView | Surfaces all actual sensitive data discovered within files which matched selected criteria |