Export the login History - Forum - Rollbase - Progress Community

Export the login History

 Forum

Export the login History

This question is answered

Hello,
I tried to generate a report which include history login for every user.
can it's possible?

Regards,

Refael.

Verified Answer
  • Hi Refael,

    Please follow the below steps to generate the report.

    1) Login as Administrator

    2) Navigate to Rollbase -> Users -> Object Definition -> Reports

    3) Click on New Report

    4) Select JavaScript report type -> Click on Next

    5)  Provide some report name

    6) Select Content Type as HTML

    7) Paste the following code in Header

    rbv_api.println("<table border='1'>");
    
    rbv_api.println(" <tr>");
    
    rbv_api.println(" <th>USR_ID</th>");
    
    rbv_api.println(" <th>LOGIN_TYPE</th>");
    
    rbv_api.println(" <th>START_TIME</th>");
    
    rbv_api.println(" <th>END_TIME</th>");
    
    rbv_api.println(" <th>IP_ADDRESS</th>");
    
    rbv_api.println("</tr>");
    
    

    8)  Paste the following code in Loop body

    var loginHistory = rbv_api.selectQuery("SELECT USR_ID,LOGIN_TYPE,START_TIME,END_TIME,IP_ADDRESS FROM $LOGIN where USR_ID =?", 100,{!id});
    
    for(var i=0;i<loginHistory.length;i++){
    
    rbv_api.println(" <tr>");
    
     for(var j=0;j<loginHistory[i].length;j++){
    
       rbv_api.println(" <td>"+loginHistory[i][j]+"</td>");
    
     }
    
    rbv_api.println("</tr>");
    
    }

    9) Paste the following code in Footer

    rbv_api.println("</table>");



    See the below screenshot for reference.



    10) Save the report
    11) Preview/Run the report.

    Sample report


    Thanks
    Srinivas

All Replies
  • Hi Refael,

    Please follow the below steps to generate the report.

    1) Login as Administrator

    2) Navigate to Rollbase -> Users -> Object Definition -> Reports

    3) Click on New Report

    4) Select JavaScript report type -> Click on Next

    5)  Provide some report name

    6) Select Content Type as HTML

    7) Paste the following code in Header

    rbv_api.println("<table border='1'>");
    
    rbv_api.println(" <tr>");
    
    rbv_api.println(" <th>USR_ID</th>");
    
    rbv_api.println(" <th>LOGIN_TYPE</th>");
    
    rbv_api.println(" <th>START_TIME</th>");
    
    rbv_api.println(" <th>END_TIME</th>");
    
    rbv_api.println(" <th>IP_ADDRESS</th>");
    
    rbv_api.println("</tr>");
    
    

    8)  Paste the following code in Loop body

    var loginHistory = rbv_api.selectQuery("SELECT USR_ID,LOGIN_TYPE,START_TIME,END_TIME,IP_ADDRESS FROM $LOGIN where USR_ID =?", 100,{!id});
    
    for(var i=0;i<loginHistory.length;i++){
    
    rbv_api.println(" <tr>");
    
     for(var j=0;j<loginHistory[i].length;j++){
    
       rbv_api.println(" <td>"+loginHistory[i][j]+"</td>");
    
     }
    
    rbv_api.println("</tr>");
    
    }

    9) Paste the following code in Footer

    rbv_api.println("</table>");



    See the below screenshot for reference.



    10) Save the report
    11) Preview/Run the report.

    Sample report


    Thanks
    Srinivas

  • Hi Srinivas,

    Thanx at lot.

    It's work.

    Best Regards,

    Refael

  • Hi Srinivas,

    Thanx at lot.

    It's work.

    Best Regards,

    Refael

  • Hi Srinivas,

    I have one more question:

    it's possible to generate this data in document template?

    Thank you,

    Refael.

  • Hi Srinivas,

    I have one more question:

    it's possible to generate this data in document template?

    Thank you,

    Refael.

  • Hi Refael,

    I think we cannot generate this report in the document template. I am not sure about it.

    You can export the login history of each user in XLS/CSV format from System info tab.

    1) Login as Administrator

    2) Navigate to Rollbase -> Users

    3) Navigate to any user details page -> System Info tab

    4) Navigate to Login History section

    5) Click on Show All button

    6) Now you can find the option "Export Full History: XLS | CSV"

    Thanks

    Srinivas

  • Hi Srinivas,

    Thanks but I want to export report automatically.

    Refael

  • Hi Rafael,

    I created a sample application. You can download from below link.

    progresssoftware-my.sharepoint.com/.../EcCtSxjBDYdLqqHCw_fJKqwB0TfhSsl5_TAsGwjT-8jAjA

    Follow the below steps

    1) Install the above application xml

    2) Navigate to Setup Home -> Batch Jobs -> Click on " CreateLoginHistory" job's Run Now (You can also schedule this job)

    3) It creates records in LoginHistory object

    4) Navigate to Dashboard Tab and click on "LoginHistory" Document template report. Login History report will be generated

    I have created a batch job which removes old login history records from LoginHistory object and creates new records.

    You can also add another "Generate Report" batch job to automatically generate this report. Schedule this job after "CreateLoginHistory" job. So that you can get the latest data in the report.

    Thanks

    Srinivas