1

If one wishes to see the logs for a particular Event Type over a period of time, the user has to manually go into each Event Log file one by one. Since one Event Log file is generated per day, this can be quite tedious. For example, if you wanted to see how many users looked at a particular Visualforce page over a 30 day period, you would have to look at 30 Event Log files.

Is there a way in which to generate a single Event Log file for the Event Types which you wish to analyse? For example, a better way would be if one could say 'for this 30 day period, show me all the logs where the EventType = 'VisualforceRequest'. That would save a lot of time.

1

No, I don't believe this is possible with the current Spring '17 functionality. The SOQL queries on EventLogFile have no way to combine the contents of the corresponding LogFile fields.

It wouldn't be too difficult to have a developer merge multiple CSV files from a query into a single combined one.

Otherwise you could try raising something on the idea exchange.

  • Thanks Daniel. "It wouldn't be too difficult to have a developer merge multiple CSV files from a query into a single combined one." - this would be done via powershell, I assume? – Andy Hitchings Feb 21 '17 at 10:09
  • 1
    Powershell is one option. I've got some basic .NET code that queries and pulls down the event log files. Combining two CSV files should just be a matter of removing one header and concatenating what is left. – Daniel Ballinger Feb 21 '17 at 18:01

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.