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.

Improve this question
1
  • we export all of our logs into SumoLogic using's Sumo's SFDC Connector App (free)
    – cropredy
    Oct 13, 2021 at 22:55

2 Answers 2

Reset to default
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.

Improve this answer
2
  • 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, 2017 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, 2017 at 18:01
0

You can use this app:https://app.salesforce-compare.com/

Create a connection, then tick the "load events" checkbox, wait a while and go to "Monitor" to view the different event types in the selected org

If you are not satisified with my visual representation of the data you can export the data for the selected time range

All the event types are exportable but only some have visual representations

Note that only "Insecure External Assets", "Login", and "Logout" are available at no additional cost

I am the developer of the app

Improve this answer
5
  • Please make your affiliation with that app more obvious than the word "my" in third paragraph of your answer. (See Expected Behavior > Avoid overt self-promotion and How to not be a spammer.) I, for one, though, would never enter my credentials into a randomly linked app that has no introduction, privacy policy, terms of service, etc.
    – Moonpie
    Oct 13, 2021 at 12:08
  • Roger that. I will clarify and add those.
    – jani_r
    Oct 13, 2021 at 12:24
  • You replied to my comment yesterday shortly after I posted it, yet you have not yet edited your answer to clarify your affiliation with the linked app.
    – Moonpie
    Oct 14, 2021 at 15:13
  • I am the developer of the app, that is my affiliation to the app. I am in the process of creating a web site where I will add all the relevant information about the app
    – jani_r
    Oct 14, 2021 at 15:34
  • For more info on the app, see salesforce-compare.com
    – jani_r
    Nov 8, 2021 at 16:31

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .