topic Re: Exporting users to a CSV on ACS Solution Engine Appliance in Network Access Control

Exporting users to a CSV on ACS Solution Engine Appliance

antonios — Sun, 10 Mar 2019 23:37:04 GMT

Hi,

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

Thanks

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

Jagdeep Gambhir — Fri, 31 Jul 2009 13:06:25 GMT

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

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

antonios — Fri, 31 Jul 2009 13:45:42 GMT

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

Jagdeep Gambhir — Fri, 31 Jul 2009 14:23:39 GMT

I don't think that is possible.

Regards,

~JG

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

Lucien Avramov — Fri, 31 Jul 2009 23:35:50 GMT

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.

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

darpotter — Wed, 05 Aug 2009 08:49:36 GMT

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

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

darpotter — Wed, 05 Aug 2009 08:59:19 GMT

Screenshot uploaded as attachment...

enjoy!