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

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Exporting users to a CSV on ACS Solution Engine Appliance

Hi,

Was wondering if it is possible to export users to a CSV file using ACS solution engine appliance.

Thanks

6 REPLIES

Re: Exporting users to a CSV on ACS Solution Engine Appliance

Hi ,

This is the only way,

To export a list of users, use the exportusers command.

exportusers [server] [username] [filepath]

http://www.cisco.com/en/US/docs/net_mgmt/cisco_secure_access_control_server_for_solution_engine/3.3/installation/guide/appliance/cliap.html#wp1205925

Regards,

~JG

Do rate helpful posts

New Member

Re: Exporting users to a CSV on ACS Solution Engine Appliance

Hi,

Thanks for your response.

The customer would like to export the realname and description field aswell.

Any idea if this is possible.

At the moment we are only get the username begin exported with the "exportuser" command.

Thanks

Re: Exporting users to a CSV on ACS Solution Engine Appliance

I don't think that is possible.

Regards,

~JG

Re: Exporting users to a CSV on ACS Solution Engine Appliance

I think the windows CSUtil.exe can export a few more fields than the ACS SE, I have not tried the SE to compare.

You can backup you DB, install ACS eval for windows and then from the command line in the \Utils directory, run "csutil -d" without the quotes. This

will create a file called dump.txt.

Name : Bubbajoe

Profile : 0

App00 USER_DEFINED_FIELD_0 STRING Bubba

App00 USER_DEFINED_FIELD_1 STRING Joebillybob

What that shows is there is a username of "Bubbajoe" that is in Group 0 (Default) and has

userdefined fields of "Bubba" and "Joebillybob", 1 and 2 respectively.

Silver

Re: Exporting users to a CSV on ACS Solution Engine Appliance

Take a look at extraxi csvsync and aaa-reports!

csvsync can remotely ask the ACS to generate a package.cab and download it.

aaa-reports! can import the database files contained in the .cab and allows you to report on its content. There is also a visual query builder tool with csv/xls export.

Requires ACS 4.1 or later (for SE) and 4.1(2) for software.

free 60 day trial available at http://www.extraxi.com

Silver

Re: Exporting users to a CSV on ACS Solution Engine Appliance

Screenshot uploaded as attachment...

enjoy!

1615
Views
0
Helpful
6
Replies