Query Event Log Files

Learning Objectives

After completing this unit, you’ll be able to:

  • Query an EventLogFile object using Developer Console.
  • View events in Salesforce Event Log File (ELF) Browser.
  • Learn about EventLogFile event types.
Note

Note

This unit relies on your understanding of Salesforce Developer Console and the Event Log File (ELF) Browser. To learn more about each, consult the links provided in this unit’s Resources section.

In this module, we assume you are a Salesforce admin with the proper permissions to enable event monitoring. If you’re not an admin for Salesforce, that’s OK. Read along to learn how your admin would take the steps in a production org. You can also follow along using a Trailhead Playground, but it takes 24 hours for events to appear in log files.

View Events in Salesforce Event Log File Browser

The Salesforce Event Log File (ELF) Browser is a Salesforce-connected web app that allows quick access to event log files. With the ELF Browser, you can easily find and download events from various time periods without a line of code. The data in the files you get from the browser can even be visualized using Tableau CRM. See the Event Monitoring Analytics App module for more information on that.

Note

Note

Make sure you have existing data in the ELF Browser—if not, then first generate some user activity. Doing so at this point gives you some data to look at when you get to Unit 3. Also, note that this provides general information such as event type and date, but all events in that date (LogFile field) won’t be visible in Developer Console.

Screenshot of ELF Browser returning zero results

If no reports have been exported from your organization in the past 24 hours, the totalSize field has a value of zero. Remember that it takes 24 hours for events to become available. You can export a report from your organization and try again tomorrow.

  1. Log in to your org.
  2. Navigate to the ELF Browser application by clicking this link: https://salesforce-elf.herokuapp.com.
  3. Click Production Login.
  4. Set the start Date.
  5. Select an event type for your search, or leave event type set to All.
  6. Click Apply.

Query Event Log Files in Developer Console

Let’s consider an example: A sales rep named Rob Burgle left your company a few weeks ago and joined a major competitor. All of a sudden, you start losing deals to this other company. You suspect that Rob downloaded a report containing confidential lead information and shared it with his new employer. Normally, you wouldn’t be able to confirm your suspicions. But with Event Monitoring, you can gather all the evidence you need to set the story straight. Let’s look at how this process works. 

It takes only a couple of clicks to open the Developer Console from Lightning Experience. The Developer Console is an integrated development environment with a collection of tools you can use to create, debug, and test applications in your Salesforce org.

To open the Developer Console from Lightning Experience:

  1. Click The quick access menu icon.
  2. Click Developer Console.

Screenshot displaying quick access menu used to open Developer Console from Lightning Experience

Now we’re ready to open the EventLogFile to query the information.

  1. Click File | Open.
  2. Under Entity Types, select Objects.
  3. In the Filter the repository field, type EventLogFile.
  4. Select EventLogFile under Entities.
  5. Click Open.

Next, select the fields for your query and click the Query button.

Screenshot displaying fields to select from for Query

Note

Note

Before proceeding to the next step, check to make sure event data is present in your org. If there isn’t data, run and export at least one report and wait 24 hours for the data to appear. 

Finally, click the Execute button to complete the query.

Screenshot displaying Query results

You can use the Query Editor in the Developer Console to execute a Salesforce Object Query Language (SOQL) query. The History pane displays your last 10 queries for quick reuse. Results are displayed in a Query Results grid.

The Query Results grid displays each record as a row. You can open, create, update, and delete records without leaving the Developer Console.

Event Log File Documentation for Event Types

The EventType field in the EventLogFile object supports events. Every event type is documented in the Salesforce Object Reference. In it, you can see the fields and their descriptions, and sample queries to use. 

For example, for the DB_TOTAL_TIME field, the event type Number is the time in nanoseconds for a database round trip, which includes time spent in the JDBC driver, network to the database, and DB_CPU_TIME. As an admin, you can compare this field to CPU_TIME to determine whether performance issues are occurring in the database layer or in your own code.

Report Event Type page

Report events contain information about what happened when a user ran a report—things like the date and time, the report name, the records referenced in the report, the number of rows and columns, and the originating user, among many others.

You can also use the REST API to interact with Event Monitoring logs; Event Monitoring is accessed through the Lightning Platform SOAP API and REST API by way of the EventLogFile object. So, you’re able to integrate log data with your own back-end storage and data marts to correlate data from multiple orgs and across disparate systems.

In the next unit, let’s explore how to download and visualize event log files to get one step closer to providing insight into malicious user behavior using Event Monitoring.

Resources

Keep learning for
free!
Sign up for an account to continue.
What’s in it for you?
  • Get personalized recommendations for your career goals
  • Practice your skills with hands-on challenges and quizzes
  • Track and share your progress with employers
  • Connect to mentorship and career opportunities