RDBMS syntax

Answered Question
Apr 14th, 2008


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,


I have this problem too.
0 votes
Correct Answer by Jagdeep Gambhir about 8 years 6 months ago
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Jagdeep Gambhir Tue, 04/15/2008 - 04:45


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 :



[3] Uploading accountactions.csv file :



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



dpatkins Tue, 04/15/2008 - 04:54


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?




This Discussion