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

Number of files grouped by sharing scope

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

Explanation: Same as above for groups.

---

5. Data Source Coverage

Number of files grouped by the datasource

           datasource_id  count
6762ff8fe194d75605bd6c17    344

Explanation: Number of sensitive files for every datasource that are processed by Access DB.