Expose USER.Status and USER.LastLoginTime time in USER table via DataQuery
In every zuora table we have created_by_id and updated_by_id. These technical ids are not very helpful by themselves. However on joining the table with USER table, we are able to identify the users. For our Client's reporting requirement, we will need Status and LastLoginTime from the USER table.
This will enable us to:
1. Filter out the rows which are updated/created by Active users.
2. Create a scheduled report on Last login time
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.