Happy Business Starts Here

Expose USER.Status and USER.LastLoginTime time in USER table via DataQuery

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