Cisco ACS dbase tools?

Abertay · ‎07-29-2008

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.

dhananjoy chowdhury · ‎07-29-2008

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

DELETE:samba

For more options of the CSUtil tool check this link

Hope this helps.

Abertay · ‎07-31-2008

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

dhananjoy chowdhury · ‎07-31-2008

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

Abertay · ‎07-31-2008

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.