Hello All,
For audit purpose I want list of users with last login and role may be now the user is not exist in system or user table but it past user was regular user, is there any history user or history activity table available in outsystem?
Hello Rashpal,
Usually user records are not hard deleted from the User entity instead they are soft deleted (deactivated) to maintain data integrity. Yet, if somehow you hard deleted them and still maintained data integrity, then I don't think OutSystems maintains any such historical data. However, for future you might consider introducing some audit data model and logic to capture these details.
Hope it helps!
Junaid
Hi!
You can find that information in the System eSpace "User" and "User_Role" entities.
Regards
Graça
Hello
Thanks for reply, Let me share with the example
I have 2 applications A1 and A2, also, I have 5 users who have roles assigned in both applications.
Case 1: I created the script between User, User_Role, and Espace to find which user logged in, in the last 1 year in the A1 application and get the list of all 5 users. which is working fine for me.
Case 2: I removed the role of 2 users for the A1 application last month, now again I need the list of users who login in the last 1 year for A1 then I ran the same query I received only 3 users in the list, but I need all 5 users in the list.
So, can we know or find that through outsystems.
Hi Rashpal,
You can join the below tables to get user data.
Also as Junaid mentioned the data is not deleted it just got InActive.
Hope it helps,
Thanks
If you look at the fields in the entities User, User_Role and Espace you can see that what you can obtain is the last time a user login in Environment , but there is no information on which applications he or she used.
To my knowledge the information on the last time a user used a application is not saved in the platform entities, if you need that info you must build an entity and the code to save it.
Sorry not been able to help.