Hi,
I have a joiner and termination rule that runs daily.
The rule give me a count of users and leavers, however, it doesn't list the actual users and their details.
Any idea on which DB table would give me such details?
Regards
Armel Lupapi
Hi,
I have a joiner and termination rule that runs daily.
The rule give me a count of users and leavers, however, it doesn't list the actual users and their details.
Any idea on which DB table would give me such details?
Regards
Armel Lupapi
The information most likely is stored in the DB, however I'm not sure where
Consider an alternative
As you are using attribute change rule, you can leverage the update managed attribute value functionality
Note: this section will appear only if you have at least one managed user attribute.
Once the rule is triggered, you will have a date value in the chosen managed user attribute
Note #2: Obviously this will not work retroactively
That information is in t_av_rule_execution_data. You can filter that table by Rule and Run IDs to get the master_enterprise_user_id. Probably other columns there would tell the difference between joiners/movers … etc.
That information is in t_av_rule_execution_data. You can filter that table by Rule and Run IDs to get the master_enterprise_user_id. Probably other columns there would tell the difference between joiners/movers … etc.