SAP Knowledge Base Article - Public

2298105 - How to generate user login data report

Symptom

  • Generate a report to fetch statistical user logon data in BizX
  • Retrieve user logon count in BizX
  • How to know who is logging in our instance?
  • How to audit who has logged in our system?
  • How to add Date and timestamp for date fields in user login report?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental

Environment

SAP SuccessFactors HXM Suite

Resolution

  1. Logon to BizX application;
  2. Navigate to Reports > Reports Center >Table Report (formerly called Adhoc Reports);
  3. Select Create New Report > Navigate till Login Data under the option of 'Report Definition Type';

 

UL1.png

 

  1. Select Login Data and click Create to start configuring the report;

UL2.png

  1. Configuring basic pills i.e. General Info, People and Columns as per the requirement;
  • Configuring  General Info:

UL3.png

  • Configuring People:

Click Refine Criteria

Select Other Filters. This will ensure to pull all the records from the system if the RBP Target Population of the administrator fetching the report covers entire organization

Select Inactive Users. This will ensure to pull records for all the users who would have been marked at inactive in the system

UL4.png

  • Configuring Columns:

Click Select Columns. Select the columns from the given list. In this example, the selected columns are listed below

UL5.png

  • You may click Preview, right top corner to retrieve abstract view of the report

 

   6. How to add Date and timestamp for date fields in user login report?

Configuration Tab > Select Data Type Configuration > Change the column configuration (date fields) from Date to Timestamp > Ok

Timestamp.JPG

   7. As shown below, click Generate button to generate the Report

UL6.png

  1. Reports will be available to download in file formats such as csv, excel, PDF and ppt
  2. It is preferable to download the report as excel, this is to provision the requirement of any custom filter via MS Excel 

See SAP Help Portal for more details on Table Reports

Note : With the Q3 2019 release, logon audit records will automatically be purged after one year. Additionally, a limit of 50 million logon audit records per year has been defined see KBA 2825543 - User Login Data Purge.

You may see users in the report without login data,  this is expected if user has not been logged in over a year as data will be automatically purged.

Is Global Assignment User ID logins included in the Login Data Report?

Before b2105:

If home user and host GA users are both active, only home user will be recorded in the login report. Unless the user using host GA’s username does the API login, then system will record GA user in login report too.

After b2105:

  • Global assignment user IDs are included in the report only if they are active in the system.
  • When GA is active, no matter who does the login, login report will record GA's user ID;
  • If user using host GA’s username does the API login, then system still record GA user in login report.
  • When GA is inactive, the login report won't record the GA's user ID and will just record the actual login user id.

See Also

See SAP Help Portal for more details on Exporting Login Data with Ad Hoc Report

See SAP Help Portal for more details on Table Reports

3067736 - How to generate user login data report using Stories in People Analytics

Keywords

Login Data, Adhoc Reports, audit log , PLA-11371, login report, report, inactive , table reports , KBA , LOD-SF-PLT , Platform Foundational Capabilities , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , How To

Product

SAP SuccessFactors HXM Suite all versions