on 03-06-2013 10:00 PM
We are running IDM Version 7.10.67 710_REL SP2.
We have an error in our provisioning of non-employee's, password is not being passed. I need a workaround till I can fix the process.
Could someone walk me through building a Pass from and ASCII file for resetting passwords of multiple users so I can get 50 or so people working.
I understand the shell pass and using the ASCII to load the data from a CSV file to a custom table on the server for the pass to read from.
Where I need help is what needs to be in the shell pass to push the passwords?
I have a maintenance job to reset 1 user at a time but I'm not sure how to modify it to accept a list from CSV
/*Select distinct mskey from mxiv_sentries where is_id ='1' and attrname = 'mx_manager' */
Select distinct mskey from mxiv_sentries where is_id ='1' and searchvalue ='A82334'
There are two scripts associated with the pass, one is a custom_initializePassword (generates a password that incorporates last name and some special characters). The other is sap_encryptPassword.
I'm thinking that I need to replace the script for the one user with something like this: select * from mxmc_rt_u.Z_MASS_Password_Reset. Then do I just create the table in studio express with the same character. Which should only need to be MSKEY for the user, I think?
Thanks for any help....
Regards,
Curtis
Hi Curtis
I think you can just change the SQL select statement for your reset job.
Select * from MASS_Password_reset
The ToIDstore would be
MSKEYVALUE %MSKEYVALUE%
changetype modify
MX_PASSWORD $FUNCTION.sap_encryptpassword(password)
Peter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.