Cisco ACS 4.2 CSV File

[ulstegner]

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

[slawford]

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. 

[ulstegner]

Hello Seve,

thank you for your assistance. That should help.

Best regards

Ulrich Stegner

[slawford]

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.