Exporting users to a CSV on ACS Solution Engine Appliance

Unanswered Question
Lucien Avramov Fri, 07/31/2009 - 16:35

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

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