Symptom
- How to know the creation dates of all users?
- An inquiry about generating an audit report to identify the creation date of users in the SAP SuccessFactors.
- Customers need a report of the creation date of all users in SuccessFactors, both active and inactive
Image/data in this KBA is from SAP internal systems, sample data, or systems. Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors HCM
Resolution
This can be achieved using the Data Inspector, there's a table that you can check which shows the user's status, username, along with it's creation date.
- Login to instance and search for Data Inspector.
- On the table, choose TABLE_USERS_SYSINFO.
- For the Filter Criteria:
- You can either setup a filter based on your preference on the available criteria. Sample, you want to gather only the active users. This will use the Valid column. You can use this 3375924 - How To check User Status Via Data inspector as a reference for the validity status and user's status can be checked on the Valid column. The possible values are listed on the KBA.:
- Valid equals f to gather the users whose Valid column is listed as f which means they are active users.
- OR, you can click the Show Data without any filtering to download ALL users' records and filter it on your own on a spreadsheet.
- You can either setup a filter based on your preference on the available criteria. Sample, you want to gather only the active users. This will use the Valid column. You can use this 3375924 - How To check User Status Via Data inspector as a reference for the validity status and user's status can be checked on the Valid column. The possible values are listed on the KBA.:
- Click Show Data after configuring the filter criteria based on your preference.
- There's a download button on the top right corner of the table that allows you to export the results.
Note: In case you haven't enabled the Data Inspector tool yet, you can refer to this 3319018 - How To Enable Feature Data Inspector article.
See Also
Keywords
SAP SuccessFactors Platform, User Creation Date, Data Inspector, TABLE_USERS_SYSINFO, User Status, User Validity, User Report, Audit Report, User Addition Date, audit, report, LOD-SF-PLT-AUDR, LOD-SF-PLT-UIM, LOD-SF-PLT-MNG, creation date, user, how to, created, date, user, report , KBA , LOD-SF-PLT-MNG , Manage user Issues , LOD-SF-PLT-AUDR , Request Audit Report (Not Change Audit) , How To
SAP Knowledge Base Article - Public