Print this page

Unable to export login History data

Knowledge Article Number 000188536
Description If you are unable to export the login History data from setup menu for your org, as an alternative you can try to export the data using workbench or data loader tool
Resolution

There is a standard table called LoginHistory which you can query using batch APEX which has higher limit to get the login history data. Simply use the query provided below to pull this data from LoginHistory table. Please be sure to replace the date range with your required date range. Once the data is ready you would be able to download it.


SELECT Id, UserId, LoginTime, LoginType , <Any other filed available in this table> FROM LoginHistory WHERE LoginTime >= 2013-11-22T00:00:00Z AND LoginTime <= 2014-01-25T00:00:00Z


Please note that only UserId is stored in this table, If you need User Name Etc.. You would need to export the user table and do V-Look up or something similar to get the user related data.

 





promote demote