Hi everyone,I was wondering if we can inject or import CSV / SQL inserts to the internal database instead of adding all users one by one
My case : users on an sql database and i wants to inject them all in one click into the AM.
We do not have a procedure with SQL to do this correctly. There are multiple tables, columns, key restraints, and encryption needed, and it is not so simple to add users via sql. What can be done is use Auth Manager Bulk Admin (AMBA) to script adding users via CSV file input, or use the Admin SDK and write your own custom administration app.
By far, the easiest way is using AMBA, since it is built-in. RSA Authentication Manager 8.4 Bulk Administration Utility (AMBA) Guide
This is a short list of ADD functions:
Here is an quick example of adding a dozen internal users, with RSA passwords, and assigning software tokens to each, using AUTA (add user and token automatic, which grabs an unassigned token and assigns it to the user) all with the same initial RSA password of support1!23000. The usernames are numeric in this example. MiscVariable is 4 so that means software token.
In the /opt/rsa/am/utils directory
Input file [add-user.csv]
One example of how AMBA can be launched against my input [and also create debug log text files to check if the command was successful.]
./rsautil AMBulkAdmin -a admin -P support1! --verbose -m 0 -i add-user.csv
NOTE: be careful with full verbose (full enhanced logging) as it can degrade performance with very large csv files. But it is great for small runs while you work out your CSV file, and any errors, while learning AMBA.
About the AUTA command (more info is in the docs)
Add User and Token AutomaticThis command automates the Add User and Token command by obtaining anunassigned token of a specified type from the system and calling the Add User andToken command using the newly acquired token serial number.
The MiscVariable field is required and is used to supply the desired token type.Acceptable values are:-1 First available unassigned token0 RSA SecurID Standard Card1 RSA SecurID PINPAD Card2 RSA SecurID Key Fob3 RSA SecurID Watch4 RSA SecurID Software Token (formerly SoftID)5 RSA SecurID Smartcard6 RSA SecurID Modem7 RSA SecurID Crypto8 RSA SecurID Proteus9 RSA SecurID USBCOSMO (SID800)10 RSA SecurID Flextoken
Thank you Edward.Great answer that will help !
Retrieving data ...