As your organization's administrator, you can run searches and take action on Meet recordings in Drive log events. For example, you can use Google Drive log events to view how frequently meetings are recorded, who is recording or downloading them, and more. Export your Drive log event data to Google Sheets and analyze it with a Sheets pivot table or Looker Studio.
Your access to log events
- Your ability to run a search depends on your Google edition, your administrative privileges, and the data source. You can run a search on all users, regardless of their Google Workspace edition.
- Your Workspace subscription provides access to the log events using either the Audit & investigation tool or the Security center.
- Premium Google Workspace editions (Enterprise Plus, Enterprise Standard, or Education Plus) provide access to the Security Center and the more advanced features of the security investigation tool. The investigation tool enables super admins to identify, triage, and take action on security and privacy issues. For details, see About the security investigation tool.
- All other Google Workspace editions can access the logs using the Audit and Investigation tool. For details, see About the audit and investigation page.
Forward log event data to Google Cloud
You can opt in to share the log event data with Google Cloud. If you turn on sharing, data is forwarded to Cloud Logging where you can query and view your logs and control how you route and store your logs.
Filter and export Drive MP4 log event data
Audit and investigation tool
-
Sign in to your Google Admin console.
Sign in using your administrator account (does not end in @gmail.com).
-
In the Admin console, go to Menu
Reporting
Audit and investigation
- Click Add a filter
- Click Document type
Tip: Scroll down to see MP4. - Click Search.
- Click Export all.
- Enter a name
The export displays below the search results table under Export action results. - Click the export name link.
The log event data opens in Google Sheets.
The export might take time to download depending on the number of users in your domain
Security investigation tool
To run a search in the investigation tool, first choose a data source. Then choose one or more conditions for your search. For each condition, choose an attribute, an operator, and a value.
-
Sign in to your Google Admin console.
Sign in using your administrator account (does not end in @gmail.com).
-
In the Admin console, go to Menu
Security
- Click Data source and select Drive log events.
- Click Add a filter
- Click Document type
Tip: Scroll down to see MP4. - Click Search.
- Click Export all.
- Enter a name
The export displays below the search results table under Export action results. - Click the export name link.
The log event data opens in Google Sheets.
Notes
- In the Condition builder tab, filters are represented as conditions with AND/OR operators. You can also use the Filter tab to include simple parameter and value pairs to filter the search results.
- If you gave a user a new name, you will not see query results with the user's old name. For example, if you rename OldName@example.com to NewName@example.com, you will not see results for events related to OldName@example.com.
Analyze your data
Use Google SheetsAfter you export the data, you can use Google Sheets to analyze it with a pivot table.
You can see which users in your organization are recording Meet video calls and how often those recordings are viewed or downloaded.
- In Sheets, open the spreadsheet that contains the Meet data.
- Select all of your data, click Data
- On the right, under Pivot table editor:
- At Rows, click Add
- At Columns, click Add
- At Values, click Add
- At Filters:
- Click Add
- Under Status, click Showing all items
- Click Ok.
- Click Add
- At Rows, click Add
After you export the log event data, you can visualize it using a Looker Studio template.
To use Looker Studio, verify that your account has Looker Studio access in your Admin console settings.
- Open the Looker Studio template.
- Click More
- Under New data source, click the Down arrow
- Choose Google Sheets and select the data file you exported from Sheets.
- Click Connect.
- Review the columns and click Add to report.
You are now in Edit mode. - At the top right, click View to enter View mode.
- Use the navigation bar on the side to review different insights into your Meet recordings.
Manage log event data
Manage search results column data
You can control which data columns appear in your search results.
- At the top-right of the search results table, click Manage columns
.
- (Optional) To remove current columns, click Remove
.
- (Optional) To add columns, next to Add new column, click the Down arrow
and select the data column.
Repeat as needed. - (Optional) To change the order of the columns, drag the data column names.
- Click Save.
Export search result data
You can export search results in the investigation tool to Google Sheets or to a CSV file.
- At the top of the search results table, click Export all.
- Enter a name
The export displays below the search results table under Export action results. - To view the data, click the name of your export.
The export opens in Google Sheets.
Export limits vary depending on your Google Workspace edition:
- Premium edition (Enterprise Plus, Enterprise Standard, or Education Plus)—The total results of the export are limited to 30 million rows (except for Gmail message searches, which are limited to 10,000 rows).
- All other Google Workspace editions—The total results of the export are limited to 100,000 rows (except for Gmail message searches, which are limited to 10,000 rows).
For more information, see Export search results.
When and how long is data available?
Take action based on search results
Rules and alert features vary depending on your Google Workspace edition:
Premium editions (Enterprise Plus, Enterprise Standard, or Education Plus)—To help prevent, detect, and remediate security issues efficiently, you can automate actions in the investigation tool and set up alerts by creating activity rules. To set up a rule, set up conditions for the rule, and then specify what actions to perform when the conditions are met. For details and instructions, see Create and manage activity rules.
All other Google Workspace editions—You can set up alerts based on log event data using reporting rules. For instructions, see Create and manage reporting rules.
Requires a premium Google Workspace edition (Enterprise Plus, Enterprise Standard, or Education Plus)
After you run a search in the investigation tool, you can act on your search results. For example, you can run a search based on Gmail log events, and then use the investigation tool to delete specific messages, send messages to quarantine, or send messages to users' inboxes. For more details about actions in the investigation tool, go to Take action based on search results.
Manage your investigations
Requires a premium Google Workspace edition (Enterprise Plus, Enterprise Standard, or Education Plus)
View your list of investigationsTo view a list of the investigations that you own and that were shared with you, click View investigations. The investigation list includes the names, descriptions, and owners of the investigations, and the date last modified.
From this list, you can take action on any investigations that you own—for example, to delete an investigation. Check the box for an investigation, and then click Actions.
Note: Directly above your list of investigations, under Quick access, you can view recently saved investigations.
As a super administrator, click Settings to :
- Change the time zone for your investigations. The time zone applies to search conditions and results.
- Turn on or off Require reviewer. For more details, go to Require reviewers for bulk actions.
- Turn on or off View content. This setting allows admins with the appropriate privileges to view content.
- Turn on or off Enable action justification.
For instructions and details, go to Configure settings for your investigations.
To save your search criteria or share it with others, you can create and save an investigation, and then share, duplicate, or delete it.
For details, go to Save, share, delete, and duplicate investigations.
Related topics
Related topics for security center
The following features require a premium Google Workspace edition (Enterprise Plus, Enterprise Standard, or Education Plus)
