Hi guys,
I need to create a report, which list all information about IT User in User Management in LifeTime. I need to write a query from sql to get it but i dont know to get infomation about teams of IT user in where. Thank guys
Hi Mike,
I think using life time APIs you can fetch the list of IT users and other information form LifeTime as well. Please refer this link : https://success.outsystems.com/documentation/11/reference/outsystems_apis/lifetime_api_v2/
regards
yeah, thank you. but i need to provide solution about SQL to handle issue
If you want to get data through then you should take dependencies of entities from System module. Below tables may be helpful to provide this informaiton. You can write SQL using these entities.
about User_developer , developer , I only get info about default Role name, user name, but it hasnt any field provide info about teams. i tried to find table , which contain team's info, but i havent found yet
You are right. Seems Teams table is not available to access.
Thank you
What is the difference between Developer and User_Developer table?
Is there a way to define if user is IT user or end-user based on User list in Users table?