cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

This community is for technical, feature, configuration and deployment questions.
For production deployment issues, please contact the TAC! We will not comment or assist with your TAC case in these forums.
Please see How to Ask the Community for Help for other best practices.

1380
Views
0
Helpful
3
Replies
Highlighted
Beginner

Cisco ACS 4.2 CSV File

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
Highlighted
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.

Highlighted

Hello Seve,

thank you for your assistance. That should help.

Best regards

Ulrich Stegner

Highlighted

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.

Content for Community-Ad