Exporting users to a CSV on ACS Solution Engine Appliance

Unanswered Question
Lucien Avramov Fri, 07/31/2009 - 16:35
User Badges:
  • Red, 2250 points or more

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.


darpotter Wed, 08/05/2009 - 01:49
User Badges:
  • Silver, 250 points or more

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

Actions

This Discussion