topic Re: RDBMS syntax in Network Access Control

RDBMS syntax

dpatkins — Sun, 10 Mar 2019 22:47:05 GMT

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

Re: RDBMS syntax

Jagdeep Gambhir — Tue, 15 Apr 2008 11:45:22 GMT

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

Re: RDBMS syntax

dpatkins — Tue, 15 Apr 2008 11:54:05 GMT

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

Jagdeep Gambhir — Tue, 15 Apr 2008 12:15:32 GMT

To delete user , use action code 101

http://www.cisco.com/en/US/docs/net_mgmt/cisco_secure_access_control_server_for_solution_engine/4.0/user/guide/ag.html#wp92082

Rest seems to be ok.

Regards,

~JG