Skip to main content
Splunk Lantern

New tables queried by a Salesforce cloud peer group

You might need to detect first-time query attempts to sensitive tables by a peer group that has previously not accessed the tables when doing the following:

Prerequisites 

In order to execute this procedure in your environment, the following data, services, or apps are required:

Example

A search might show first-time query attempts to sensitive tables by a peer group that has previously not accessed the tables in question. This detection can help prove that individuals within the organization are not abusing or misusing legitimate access to assets that store and process personal data. Because so many people in your organization have access to Salesforce, you want to monitor regularly for new table queries. 

To optimize the search shown below, you should specify an index and a time range.

  1. Populate the lookup_sfdc_usernames lookup provided by the Salesforce Add-on with live values from your site.
  2. Run the following search: 
QUERY=* EVENT_TYPE=API OR EVENT_TYPE=BulkAPI OR EVENT_TYPE=RestAPI 
| rex field=QUERY max_match=12 "\s(?i)from\s*(?<QUERY_TABLE>[\w_]*)" 
| search QUERY_TABLE="Account*" OR QUERY_TABLE="Contact*" OR QUERY_TABLE="Opportunity*" 
| lookup lookup_sfdc_usernames USER_ID 
| stats earliest(_time) AS earliest latest(_time) AS latest BY Username, QUERY_TABLE
|where earliest > relative_time(now(), "-1d@d")

Search explanation

The table provides an explanation of what each part of this search achieves. You can adjust this query based on the specifics of your environment.

Splunk Search Explanation

QUERY=* EVENT_TYPE=API OR EVENT_TYPE=BulkAPI OR EVENT_TYPE=RestAPI 

Filter for API-related events where a query is defined.

|rex field=QUERY max_match=12 "\s(?i)from\s*(?<QUERY_TABLE>[\w_]*)" 

Extract the table name from the query. The rex captures all the word characters after the "from" clause in the SQL query. 

|search QUERY_TABLE=Account* OR QUERY_TABLE=Contact* OR QUERY_TABLE=Opportunity*

Filter the results to include only queries of sensitive tables (Account, Contact, or Opportunity), or their derivatives. 

|lookup lookup_sfdc_usernames USER_ID

Convert the SFDC USER_ID into a friendly username via a lookup. 

|stats earliest(_time) AS earliest latest(_time) AS latest BY USER_NAME, QUERY_TABLE

Calculate the earliest and the latest time this combination of fields occurred.

|where earliest > relative_time(now(), "-1d@d")

Determine whether the earliest time this value was seen was within the last day.

Result

While there are no traditional false positives in this search, there will be a lot of noise. Every time this search runs, it will accurately reflect the first occurrence in the time period you're searching over (or for the lookup cache feature, the first occurrence over whatever time period you built the lookup). You should not review these alerts directly (except for high sensitivity accounts), but instead use them for context or to aggregate risk.

For most environments, these searches can be run once a day, often overnight, without a lag. If you want to run this search more frequently, or if this search is too slow for your environment, leverage a lookup cache. 

When this search returns values, initiate your incident response process and identify the peer group demonstrating this behavior. Capture the time of the event, the user's role, and tables queried. If possible, determine the system used and its location. Contact the user and their manager to determine if the download is authorized, and then document that it was authorized and by whom. If you cannot find authorization, the user credentials may have been used by another party and additional investigation is warranted.

GDPR Relevance: This search can be considered an effective security control, as required by Article 32. This is applicable to processing personal data from the controller and needs to also be addressed if contractors or sub-processors from third countries or international organizations access and transfer personal data (Article 15).

  • Was this article helpful?