Skip to main content
 
 
Splunk Lantern

New application accessing the Salesforce API

 

Your Salesforce cloud deployment contains your company's most critical customer information. To help protect this data, you want to regularly monitor users who connect to SFDC's reporting API with new clients.

Required data

Salesforce data

Procedure

  1. Populate the lookup_sfdc_usernames lookup provided by the Salesforce Add-on with live values from your site.
  2. Run the following search. You can optimize it by specifying an index and adjusting the time range.
|search CLIENT_NAME=* EVENT_TYPE=API OR EVENT_TYPE=BulkAPI OR EVENT_TYPE=RestAPI
|lookup lookup_sfdc_usernames USER_ID
|stats earliest(_time) AS earliest latest(_time) AS latest BY USER_ID, CLIENT_NAME
|eval peergroup_name="None", isOutlier=case(len(peergroup_name)>0 , if(isnotnull(earliest) AND earliest>=relative_time(maxlatest,"-1d@d") AND isnull(peerpast),1,0), earliest >= relative_time(maxlatest, "-1d@d"), 1, 1=1, 0)

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

|search CLIENT_NAME=* 

Filter for events where the CLIENT_NAME is set to a value. 

EVENT_TYPE=API OR EVENT_TYPE=BulkAPI OR EVENT_TYPE=RestAPI

Filter for API-related events.

 

|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, CLIENT_NAME

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

| eval peergroup_name="None", isOutlier=case(len(peergroup_name)>0 , if(isnotnull(earliest) AND earliest>=relative_time(maxlatest,"-1d@d") AND isnull(peerpast),1,0), earliest >= relative_time(maxlatest, "-1d@d"), 1, 1=1, 0) If the earliest time we have seen that value was within the last day, that means the first time we've ever seen it just happened, and it qualifies as anomalous.

Next steps

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 user demonstrating this behavior. Capture the time of the event, the user's role, and application. 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: Under the GDPR Article 30, organizations are required to maintain a record of processing activities, including contact details of the controller, the purposes of processing, description of the categories of data subjects and personal data processed—as well as the categories of recipients to whom the personal data has been or will be disclosed including recipients in any other countries. Interactions from new applications—whether for legitimate purposes or as a result of malicious activity—can create a non-compliance condition if they are not documented properly. This situation may not impact organizations who employ fewer than 250 persons and, therefore, may not have critical categories of personal data for processing.

Monitoring Salesforce.com API activity can help identify connections from new applications or clients that might not be whitelisted or documented. The timely and accurate reporting of a non-compliance state can prompt the Data Privacy Officer to proactively follow up and update documentation, and report to the authorities in a timely manner if appropriate.

Finally, you might be interested in other processes associated with the Protecting a Salesforce cloud deployment use case.