Find All Externally Shared Google Drive Files for a Specific OU with GAT+

Want to find all the externally shared Google Drive files for a specific OU owned by users that are also ‘shared out’ to specific external users?

The GAT+ Drive audit can easily do this.

Step 1: Filter Externally Shared Google Drive Files for a Specific OU #

Navigate to GAT+ > Drive > Files 

• Apply filter (2)
• In the filter option select the following steps
  • Type – User/Group/OU search (3)
  • Org. Unit – select the Organization unit you need (4)
    • Include the Sub. Org
  • Ownership – Owned (6)
  • Under Definition Add the rule
    • Sharing flag contains Shared Out (7)

Step 2: Result #

When the filter is applied the result will return all the Google Drive files/folders owned by the users of the selected OU that are also “Shared out” to External users.

All files and folders will have a Sharing Flag equal to Shared Out.

Step 3: Alternative filters #

The results will include all Shared Out files/folders including “Public/Everyone and Public/Everyone with link permissions.

Change the Sharing Flag to a different filter to see different results.

For example:

• Public – view all files owned by users of the OU and with Public permissions
• Public with a link – view all files owned by users of the OU and with Public with link permissions
• Specific external users – view all files owned by users of the OU shared with only specific external users (excluding the Public and Public with link permissions)