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

Cisco ACS dbase tools?

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.

4 REPLIES

Re: Cisco ACS dbase tools?

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.

New Member

Re: Cisco ACS dbase tools?

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?

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

New Member

Re: Cisco ACS dbase tools?

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.

173
Views
0
Helpful
4
Replies
CreatePlease to create content