Notification on a transfer certification for a user where cert was not launched

[kfoley1]

Hello - we currently have a User Update Rule to launch a User Manager certification on Cost Center ID change. The workday import runs every hour on the hour and we have the Launch_Certification job scheduled to run every hour after 12 minutes. We just had scenario where the Workday job ran off cycle so the Launch_Certification job did not run immediately after and the certification was not launched. We are looking for a way to set up monitoring/reports to identity this scenario where a user's cost center ID changes but a certification was not launched. Any ideas?

[rushikeshvartak]

You can create analytics report with execution rule history table

[Lakhitha]

Hi Rushikesh,

Thanks for your response.

Could you please provide us the exact table name to create the analytics?

Thanks & Regards,

Lakhitha

[rushikeshvartak]

• usershistory --> To find costceneter in updated
• Below are certification table 
  • certifications
  • campaigns 
  • 

[Lakhitha]

Hi Rushikesh,

Thanks for your response.

If we check the campaign table, we can find the campaigns that are launched due to cost center updates. But for multiple users, if the cost center value is changed then all these users will be included in single campaign. Suppose out of 5 users for 1 user if the campaign is not launched then we will not be able to identify that user.

Is there any way we can identify that user?

I have verified few of the campaign tables and I'm unable find the link between campaign and the users.

Thanks & Regards,

Lakhitha

[rushikeshvartak]

• You need to find users whos cost center has been updated in usershistory table
• Based on users found search in campaigns table if campiagn has been created or not.
• The user whose campaign was not created is a problem.

[Lakhitha]

Campaign table doesn't have user information.

I have verified few other tables as well I'm unable to find the link between campaign and it's users.

[rushikeshvartak]

Certification_User_Status	This table is mainly used in the User Manager campaign and it holds the certification_user table key value along with the certification key, certified to log the actions taken by the end user.	Certification_User
Certification_User_Account_Status	This table is mainly used in the User Manager, Service Account, and Application Owner campaigns and it holds the certification_user, and Certification_account tables key values along with the certification key, certified to log the actions taken by the end user.	Certification_User Certification_Account Certification_Role Cert_Role_User_Account

https://docs.saviyntcloud.com/bundle/EIC-Database-Schema-Reference/page/Content/Database-Schema-Refe...

[dgandhi]

In your use update history, do you cost center value being changed? If yes can you check if rule run is specified over there?

Ideally you shouldnt be running launch certification job so frequently. You can schedule it to run once a day, this way it will consolidate all the certification (based on user updates) and launch certification at once for all certifiers.