0

Is there a way to find if the user insert the records is that through bulk statement or individual insert records?

I have look DebugLog and ApexLog object but does not give me a lot of information about number of records insert in one sing insert statement.

Is that possible to even find?

for an example:

I want to know if the records inserted came through individual insert like adding records one by one going through object or was it through a bulk statement.

  • Did you check event logs for any cues? – RedDevil May 9 '19 at 19:31
  • EventLogFile did not give any information what i'm looking for – Nick Kahn May 9 '19 at 19:40
  • 1
    I checked event logs API type it gives information on user, sobject,operation type and number of rows processed in one go, is that what you need? – RedDevil May 11 '19 at 4:24
  • what object or endpoint you find those information? can you post this as answer with detail and yes that's what i'm looking for. – Nick Kahn May 13 '19 at 18:11
  • Done. Posted the answer – RedDevil May 13 '19 at 18:18
0

Since you have event logs enabled in our Org. Use this heroku app to open your sandbox and then it shows downloadable CSV's of all event types. If you download event type API it gives information of organization/User/sObject/Operation/Number of records. Sample screenshots below.

enter image description here

There is also a trailhead module on viewing event files in case you wish to go through

| improve this answer | |
  • while this would work for an inbound API call to SFDC, it wouldn't tell you anything about singleton vs bulk DML done within APEX – cropredy May 13 '19 at 21:17
  • @cropredy, if you look at rows_processed it will give you number of rows processed in a single transaction and if this user only uses the Application it gives you the hint that some bulk update done by the user through UI. – RedDevil May 14 '19 at 5:07
  • Hmm. Does Event Type API include DML done by the standard UI or an Apex controller? – cropredy May 14 '19 at 6:19
  • @cropredy - It includes both, there is a separate event type for apex execution which includes the class and method information, there is one for lightning page views which shows UI page hits. Basically a bit of detective investigation to combine all the information may be using session keys – RedDevil May 14 '19 at 9:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.