How to Create the Report for User logged History in Salesforce



Create a User Login report  (Classic):


  1. From the Reportstab, click New Report
  2. Go to Select Report Type, select the Administrative Reportsfolder, then click
  3. Click Create.
  4. From the drop-down next to “Preview,” select Matrixas the Report Format.
  1. Drag the groupings you would like to use in your report, dropping the fields on the sections. Include the Login
    Date
  2. After selecting the Login Date field, use the drop-down menu on Login Dateand select Sort group ascending and group your dates by day (or any other period of time).
  3. If you have any numeric field that you want to add to your report, drop it into the body of the Matrix, and then select SumAverageMax, or Min.
  • The sum is useful to see the total for this field by row or column. For example:Sum of active users or Sum of partner users.
  1. Select the filter Criteria you prefer. For the Standard Filters you can choose: 
  • View= Active Users
  • Date field= Login Date
  • Range= Last 7 days
  • Login Status= Success  (this filter is optional).
  1. Save and Run your report Successfully!

Prepared By,
Tamilselvan Selvaraj,
Software Engineer,
Merfantz Technologies.