on Oct 26, 2017I am currently working on a fulfillment workflow that detects when an account is being created and generates a mail to the user's manager letting them know the password. The password is a static value set in an Account Template and accounts are only created when a request is made for a user without an account to be granted an entitlement. My questions are:
1 - Is this available as a PublicData variable that can be called within the workflow?
2 - If so, what is the syntax used to call it?
The account template is called AD Account Template.
I currently have a SQL select node running before the generate e-mail node with the following command:
SELECT default_value as workflowpwdmail FROM T_AV_ACCOUNT_TEMPLATE_PARAM
WHERE name = 'Password' AND
Account_Template_Id = 1
Where the variable is type Job. This is then called within the body of the mail as ${jobUserData_WORKFLOWPWDMAIL}
This does work but it is querying internal tables, which we are trying to do less of.
Cheers,
Craig
To refer PublicData variable, u can use this syntax in Set Value node ${PublicData_avform_mytextfield}
Regarding email to User's Manager on password, there are 2 ways that i used before.
#1. Ur AD still use Default AFX Fulfillment. Ur request form point to custom fulfillment workflow that perform the following:-
- call provisioning command to Create AD account (create account with random password)
- Set Value newPassword='abc123'
- then call provisioning command to Reset Password on AD account(with newPassword value) and then email the newPassword to User's Manager.
#2 . Ur AD still use Default AFX fulfillment. Ur Request form point to a custom fulfillment workflow that perform following:-
- call provisioning command to Create AD account (create account with random password)
- Set Value newPassword='abc123'
- Then call a IMG Web service to perform Reset password
Reset password for an account
<AccountChange>
<Operation>ResetPassword</Operation>
<User>User's Manager</User>
<Account>UserAccount</Account>
<BusinessSource>AD</BusinessSource>
<Password>abc123</Password>
</AccountChange>
- After trigger MG WebService on reset password, IMG will generate another change request to reset password.
- Later User's Manager able to view user password under View My Password page. Note: Password is not send via email. There will be email notification on available password to view.