Jamboard files in Drive log events

Understand how Jamboard files are used in your domain

Depending on your Google Workspace edition, you might have access to the security investigation tool, which has more advanced features. For example, super admins can identify, triage, and take action on security and privacy issues. Learn more

As an administrator, you can run searches related to Jamboard files in Drive log events. For example, you can use Google Drive log events to view how frequently Jams are being created, who is creating or editing them, and more. You can then export your Drive log event data to Google Sheets and analyze it with a Sheets pivot table.

Drive log events are searchable for up to 6 months after the event occurred. Learn more about Data retention and lag times.

Forward log event data to Google Cloud

You can opt in to share 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.

The type of log event data you can share with Google Cloud depends on your Google Workspace, Cloud Identity, or Essentials account.

Filter and export Drive log event data for Jamboard usage

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.

Audit and investigation tool

To run a search for log events, first choose a data source. Then, choose one or more filters for your search.

  1. Sign in to your Google Admin console.

    Sign in using your administrator account (does not end in @gmail.com).

  2. In the Admin console, go to Menu and then Reportingand thenAudit and investigationand thenDrive log events.
  3. Click Add a filter, and then select an attribute.
  4. In the pop-up window, select an operatorand thenselect a valueand thenclick Apply.
    • (Optional) To create multiple filters for your search, repeat this step.
    • (Optional) To add a search operator, above Add a filter, select AND or OR.
  5. Click Search.

    Note: Using the Filter tab, you can include simple parameter and value pairs to filter the search results. You can also use the Condition builder tab, where the filters are represented as conditions with AND/OR operators.

Security investigation tool
Supported editions for this feature: Frontline Standard; Enterprise Standard and Enterprise Plus; Education Standard and Education Plus; Enterprise Essentials Plus; Cloud Identity Premium. Compare your edition

To run a search in the security 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

  1. Sign in to your Google Admin console.

    Sign in using your administrator account (does not end in @gmail.com).

  2. In the Admin console, go to Menu and then Securityand thenSecurity centerand thenInvestigation tool.
  3. Click Data source and select Drive log events.
  4. Click Add Condition.
    Tip: You can include one or more conditions in your search or customize your search with nested queries. For details, go to Customize your search with nested queries.
  5. Click Attributeand thenselect an option.
    For a complete list of attributes, go to the Attribute descriptions section (later on this page).
  6. Select an operator.
  7. Enter a value or select a value from the list.
  8. (Optional) To add more search conditions, repeat steps 4–7.
  9. Click Search.
    You can review the search results from the investigation tool in a table at the bottom of the page.
  10. (Optional) To save your investigation, click Save and thenenter a title and descriptionand thenclick Save.

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 using Google Sheets

After 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 using Jamboard and how many unique users are taking action on those Jams.

  1. In Sheets, open the spreadsheet that contains the Jamboard data.
  2. Select all of your data, click Insertand thenPivot tableand thenCreate.
  3. On the right, under Pivot table editor:
    • At Rows, click Addand thenOwner.
    • At Values, click Addand thenDocument ID and Addand thenActor.
    • For the Values of Document and Actor, change Summarize by to COUNTUNIQUE.
    • At Rows, change the order to Descending and Sort by to COUNTUNIQUE:
      1. Document ID will show how many unique Jams that owner has had action taken against by themselves or other users.
      2. Actor will show how many unique users have taken action against that owner’s Jams.

Manage log event data

Manage search results column data

You can control which data columns appear in your search results.

  1. At the top-right of the search results table, click Manage columns .
  2. (Optional) To remove current columns, click Remove .
  3. (Optional) To add columns, next to Add new column, click the Down arrow  and select the data column.
    Repeat as needed.
  4. (Optional) To change the order of the columns, drag the data column names.
  5. Click Save.

Export search result data

You can export search results to Google Sheets or to a CSV file.

  1. At the top of the search results table, click Export all.
  2. Enter a name and then click Export.
    The export displays below the search results table under Export action results.
  3. To view the data, click the name of your export.
    The export opens in Google Sheets.

Export limits vary:

  • The total results of the export are limited to 100,000 rows (except for Gmail message searches, which are limited to 10,000 rows).
  • Supported editions for this feature: Frontline Standard; Enterprise Standard and Enterprise Plus; Education Standard and Education Plus; Enterprise Essentials Plus; Cloud Identity Premium. Compare your edition

    If you have the security investigation tool, the total results of the export are limited to 30 million 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

Create activity rules & set up alerts
  • You can set up alerts based on log event data using reporting rules. For instructions, see Create and manage reporting rules.
  • Supported editions for this feature: Frontline Standard; Enterprise Standard and Enterprise Plus; Education Standard and Education Plus; Enterprise Essentials Plus; Cloud Identity Premium. Compare your edition

    To help prevent, detect, and remediate security issues efficiently, you can automate actions in the security 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.

Take action based on search results

Supported editions for this feature: Frontline Standard; Enterprise Standard and Enterprise Plus; Education Standard and Education Plus; Enterprise Essentials Plus; Cloud Identity Premium. Compare your edition

After you run a search in the security 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 tool to delete specific messages, send messages to quarantine, or send messages to users' inboxes. For more details, go to Take action based on search results.

Manage your investigations

Supported editions for this feature: Frontline Standard; Enterprise Standard and Enterprise Plus; Education Standard and Education Plus; Enterprise Essentials Plus; Cloud Identity Premium. Compare your edition

View your list of investigations

To 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.

Configure settings for your 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.

Share, delete & duplicate 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.

Was this helpful?

How can we improve it?
true
Start your free 14-day trial today

Professional email, online storage, shared calendars, video meetings and more. Start your free Google Workspace trial today.

Search
Clear search
Close search
Google apps
Main menu