Access Governance Statistics

1. Core Directory Statistics

Number of users

 count
   391

Explanation: The number of users in the Active directory.

Number of groups

 count
   320

Explanation: The number of groups in the Active Directory.

Number of files

 count
   344

Explanation: The number of files whose permissions are processed by Access DB.

2. Data Privilege Analysis

Number of users count against data privilege

data_privilege_level  count
                None      1
                NONE    390

Explanation: Number of users with different data privilege levels. NONE data privilege means some workflow is still pending which will eventually populate data privilege level.

Number of groups count against data privilege

data_privilege_level  count
                NONE    320

Explanation: Same as above for groups.

3. File Access Patterns

sharing_scope  count
         None    333
       PUBLIC      2
 ORGANIZATION      9

Explanation: Sharing scope is a special field to indicate that a file has been shared publicly or with all the people of the ORG (organization). None means it's shared with individual groups and users.

Number of files grouped by sensitivity level

sensitivity_level  count
             None    344

Explanation: Number of files with different sensitivity like High, Medium, Low.

Number of files with excessive access

 count
     0

Explanation: Excessive access means that a file can be accessed by a more than 'X' number of people.

Number of files with link-based access

 count
   240

Explanation: An accessor for a file can be directly added to the file or they can be sent a link to access a file.

Number of files with cross-department access

 count
     0

Explanation: Number of files where accessors of the file are from different department than the department of the owner.

4. High-Access Analysis

Top 10 files with highest user accessors

Copyuser_count   name                                                                               id
        5        TKD Attorney Law Schools- D I (02295478xA1AB5) (02432222xA1AB5).XLSX               6763004211f10d82e44befc7
        3        Full Service and Italy Practice Capabilities_February 2023 (1).pdf (English).pdf   6763001b11f10d82e44be3d6
        3        1. Upgrade to docx preserve layout.doc                                             676301e911f10d82e44c0396
        3        Bounce Back Emails.xlsx                                                            6763011311f10d82e44bfb34
        3        TKD Model Engagement Letter - READ ONLY (00254783-13xA1AB5).doc                    676302a711f10d82e44c0ed2
        3        Compare PDF PowerPoint demo modified 2013.pdf                                      676301fa11f10d82e44c03e5
        4        AFLAC Supplemental Plans(170931878.1).pdf                                          6763028411f10d82e44c0ea2
        3        Book Tracker (02256468xA1AB5).XLSX                                                 6763001311f10d82e44be36e
        3        Compare PDF for PowerPoint demo original 2013.pdf                                  676301bf11f10d82e44c01a6

Explanation: This provides top 10 files where number of user accessors are highest.

Top 10 files with highest group accessors

Copygroup_count  name                                                            id
      2          Superseded - NYU.Edelman - Reply (4.27) w LSD edits.docx        6763035511f10d82e44c10ab
      1          Dkt 133.pdf                                                     6763032b11f10d82e44c1003
      2          Exchange Migration List Nov 2020 (02231853xA1AB5).xlsx          6763024d11f10d82e44c0c2b
      2          Memo for Hyperlink Training (02226527xA1AB5).DOCX               676303a711f10d82e44c1366
      1          Epic Production Letter_2020-6-9.pdf                             676303ac11f10d82e44c14ea
      1          Docket.pdf                                                      676304d011f10d82e44c1cb2
      1          Invoice_EPIC02200 Generic Pharma JDG - Epic Feb, 2020.pdf       6763050211f10d82e44c1e41
      1          Edgworth 2.26.20 Invoice.pdf                                    6763064011f10d82e44c289b
      1          39 Henry Schein.pdf                                             6763045b11f10d82e44c1b8e
      2          ExMboxReport v1.3.xlsx                                          6763023c11f10d82e44c09ad