topic Re: Cisco ACS dbase tools? in Network Access Control

Cisco ACS dbase tools?

Abertay — Sun, 10 Mar 2019 23:00:00 GMT

Hi,

I'm looking for an easy way to purge 5,000 users from the Cisco ACS database.

Are there any tools that will allow me to script account deletion?

thanks,

matt.

Re: Cisco ACS dbase tools?

dhananjoy chowdhury — Wed, 30 Jul 2008 04:06:55 GMT

Hi,

you can use the "CSUtil.exe" utility to delete users from command line.

Suppose you want to delete users alpha,beta,zeta

first create a text file suppose del_users.txt , which would look something like this:

OFFLINE

DELETE:alpha

DELETE:beta

DELETE:zeta

Then go to bin directory under the ACS install folder and then execute this

csutil.exe -i del_users.txt

You can also add user "venus" in Group 2 and delete user "samba" with this then use something like this

OFFLINE

ADD:venus:PROFILE:2:CSDB:password123

DELETE:samba

For more options of the CSUtil tool check this link

http://www.cisco.com/univercd/cc/td/doc/product/access/acs_soft/csacs4nt/csnt21/apimport.htm

Hope this helps.

Re: Cisco ACS dbase tools?

Abertay — Thu, 31 Jul 2008 11:28:19 GMT

Hi,

thanks for that.

Do you know if there is any way to extract a list of usernames and the 'real name' field from the supplementary info?

If you dump the entire databse it seems to be there but i would need to find some way of extracting that data.

Name = Username

App00 USER_DEFINED_FIELD_0 = Real name

thanks,

Matt

Re: Cisco ACS dbase tools?

dhananjoy chowdhury — Thu, 31 Jul 2008 14:11:12 GMT

Hi Matt,

You extract the username / real name from the dump file using Perl / shell scripts.

Also if you only need the list of usernames with groupnames, then you could use the command

csutil.exe -u

this will dump the usernames with groups in a file "users.txt".

Re: Cisco ACS dbase tools?

Abertay — Thu, 31 Jul 2008 14:16:59 GMT

Hi,

Its more just real name and username i require so the group option isnt of much use i'm afraid.

Do you have any sample scripts that will parse that log?

thanks.