03-24-2011 09:39 AM - last edited on 03-25-2019 05:27 PM by ciscomoderator
Hello,
I would like to add user (mac-addresses) to the ACS4.2 via RDBMS with a .csv file. How can I simultaneously add
supplimentary user infos, like Real Name and Description ?
Have anyone maybe a sample csv file for such a case ?
Ulrich
03-27-2011 10:12 PM
Hi Ulrich,
The following guides explain how to use the accountActions.csv file with RDBMS to create a user. They also contain a sample csv files. http://www.cisco.com/en/US/docs/net_mgmt/cisco_secure_access_control_server_for_windows/4.2/configuration/guide/rdbms_sync.html#wp1019936
The following table details the user specifc attributes you can set.
In your case to create the new user and set the name and descritpion you would use action 100 to add the user setting both the username and password as the MAC address, and then action 1 to set the user defined fields for name and description as follows:
SequenceId,Priority,UserName,GroupName,Action,ValueName,Value1,Value2,DateTime,MessageNo,ComputerNames,AppId,Status
1,1,00-01-23-45-67-89,Group 1,100,,00-01-23-45-67-89,,1/01/11 15:00,,,,0
2,1,00-01-23-45-67-89,,,USER_DEFINED_FIELD_1,Real Name,TYPE_STRING,,,,APP_CSAUTH,0
3,1,00-01-23-45-67-89,,,USER_DEFINED_FIELD_2,Description,TYPE_STRING,,,,APP_CSAUTH,1
I look forward to hearing how you go.
Steve.
03-28-2011 11:23 PM
Hello Seve,
thank you for your assistance. That should help.
Best regards
Ulrich Stegner
03-30-2011 05:41 PM
Hi Ulrich,
Thanks for your reply. I look forward to hearing how you go. If this solves your issue, please feel free to mark your question as answered.
Regards,
Steve.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide