cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2178
Views
0
Helpful
3
Replies

Cisco ACS 4.2 CSV File

ulstegner
Level 1
Level 1

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

3 Replies 3

slawford
Cisco Employee
Cisco Employee

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

http://www.cisco.com/en/US/docs/net_mgmt/cisco_secure_access_control_server_for_windows/4.2/user/guide/A_RDBMS.html#wp135188


The following table details the user specifc attributes you can set.

http://www.cisco.com/en/US/docs/net_mgmt/cisco_secure_access_control_server_for_windows/4.2/user/guide/A_RDBMS.html#wp78134

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.

Hello Seve,

thank you for your assistance. That should help.

Best regards

Ulrich Stegner

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.