Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

RDBMS syntax

Hello.

I am trying to do a bulk import of NAS to predefined ACS NDGS. Currently, I have a service running that ftps the accountActions file to our ACS 4.1 appliances.

I do understand the code, but sometimes you need 2 or 3 lines to create a transaction, I was wondering if some could help me with the syntax to add a NAS to a Network device group. Or if there is a link that will better explain this process, I would glad take that. I will be deleting users in groups as well in the very near future.

Thank you,

Dwane

1 ACCEPTED SOLUTION

Accepted Solutions

Re: RDBMS syntax

3 REPLIES

Re: RDBMS syntax

Dwane,

To add a list of device into ACS Appliance, we need to make use of RDBMS Synchronization section in ACS...

[1] We need to create a file accountactions.csv file. One sample templete to add a NAS device is attached :

In the example I have created accountactions.csv to add NAS devices. And

after adding NAS devices, assigning them to a Network Device Group. If we donot want to assign devices to an NDG, then we may take out lines with action code 252. Action code 250 to add NAS devices.

[2] Information regarding codes and accountactions.csv file :

http://www.cisco.com/univercd/cc/td/doc/product/access/acs_soft/csacsapp/csa

pp40/ugse40/ag.htm#wp78096

[3] Uploading accountactions.csv file :

http://www.cisco.com/univercd/cc/td/doc/product/access/acs_soft/csacsapp/csa

pp40/ugse40/sad.htm#wp756877

Please open accountactions.csv file with Excel, and make appropriate changes, an upload the file.

Regards,

~JG

New Member

Re: RDBMS syntax

JG

And to delete a user from a group, I would just put in one line such as:

14 0 jsmith wireless 102 ?

And to move a user to a group, it would be:

15 0 jsmith nonwireless 106

Does this look correct?

Thanks

DWane

Re: RDBMS syntax

363
Views
0
Helpful
3
Replies
CreatePlease to create content