I need to be able to extract all of the configuration info from the Centralized Configuration and put it in a single file that I can use either for Drift Management or to send to Support.

How can I easily do this?

Legacy ID:KA430289

Note:
The described procedure on this article applies until version 9.1.03. From AR 9.1.04 onwards the Centralized configuration is included in the Zip file when using the Log Zipper in the Maintenance Tool located in:
(Windows) Go to the <ARSystemServerInstallDir>\arsystem folder, and run the ARSystemMaintenanceTool.cmd file.
(UNIX) Go to the <ARSystemServerInstallDir>/arsystem directory and run the ./ARSystemMaintenanceTool.sh file.
In the ARSystemLogs.zip file, mainly in the Temp directory the file containing the Centralized Configuration export will be: CentralConfigData.csv

Important!
In versions 9.1.04 to 18.08, the CentralConfigData.csv file is incorrectly limited to the MaxGetList size. So, if your MaxGetList is set to 1000, the CSV file will only contain the first 1000 entries in the Central Config.
This has been identified as a defect.
The workaround is to increase the Max Entries Per Query before running the LogZipper and then set it back down once the file is created.


For 9.x versions up to v.9.1.03 please use the below procedure.

There are a couple of ways to go about this.

1- You can create an AR System Report against the AR System Configuration Component Setting form.
This will allow you to export the data to a CSV file that can be opened in Microsoft Excel.

2- You can also use database tools to export the data directly from the underlying tables into a CSV file.
Unless you prefer to use database tools, or are unable to login and create a report, follow the 6 easy steps for 'Using a Report' below.

Using a Report
1.  From a Web Browser, log into the ARSystem server as an Admin account.
Perform a Search on the AR System Configuration Component Setting form:

Note: This form is setup to display chunks of 1000. If this is a server group, you will need more than one chunk in order to display all the records. But you can perform the report by simply deselecting any records.

2.  Deselect any highlighted records so that no records are selected. 
- Click on the Report button to create a report.
- After the first time you do this, you can simply re-use the report that you create.

For the first time, we will create a new report.

   

3.  Click on the green + to create a report:
      Type = AR System
      Form  = AR System Configuration Component Setting
      Name =  CentralConfigReport

4.  Click OK to start building the report.
         a- Set the appropriate information leaving the Report Format = Record
         b- From the Fields Tab, add the following fields in this order:
                      Component Type,  Component Name, Setting Name, Setting Value,Configuration Component GUID, Configuration Setting GUID
         c- In the Sorting tab choose the following fields in this order:
                      Component Type, Component Name, Setting Name
         d- Click on Save to save the report.
         e- Go back to the AR System Report Console and refresh.
         f- Your new report should show up. If you do not get back to this point, simply repeat steps 1 and 2 above and you should see the report

5.  Select the new report and configure it to create a CSV file.



Destination = File
Format = CSV
Filename = c:\temp\CentralConfig9Sep2015.csv   (or an appropriate path and filename)

6.  Click  Run.
You should get prompted to Open or Save your file.

The contents will look like this:

Using Database Tools
1.  SQL Server
        a.  Open up the SQL Server Management Studio. Open a New Query Window on the ARSystem database
        b.  Perform the folllowing query to identify the database view associated with the Central Config  data:
                   select viewname from arschema where name='AR System Configuration Component Setting'
        c.   Using the result from the prior query as the tablename, perform the following query:
                   select Component_Type, Component_Name, Setting_Name, Setting_Value from AR_System_Configuration_Comp14


Note: If you do not see a Results Grid,  click on the 'Query' Pulldown menu and choose 'Results'  --> 'Results to Grid'  and run the query again

        d.  Click into the Results grid. 
               - Right-Click inside the grid and choose 'Select All'.
               - Right-click again and choose 'Save Results As'.
               - Choose a CSV Filetype.
        e.   Name the file and you are done.


2.  Oracle
        a. If you use Oracle SQL Developer, you can perform the same steps as with SQL Server. Perform the SQL statements, click click in the Grid and Export to a CSV file
        b. From SQLPlus.
               1.  Login into SQLPlus as the ARAdmin user.

               2.  Perform the following SQL statement to identify the database view associated with the Central Config data:
                       select viewname from arschema where name='AR System Configuration Component Setting'

               3.  Issue the following SET statements to get the best output:
                       SET HEADING OFF FEEDBACK OFF ECHO OFF PAGESIZE 0
                       set colsep ,
                       set pagesize 0  
                       set trimspool on
                       set headsep off 
                       set linesize 500
                       set numw 10

               4. Redirect the output to a CSV file of your choice, for example:
                     spool c:\temp\ccout.csv

               5. Using the result from the prior query as the tablename, perform the following query:
                      select 'Component Type'||','||'Component Name'||','||'Setting Name'||','||'Setting Value' from dual union select                  
                      TRIM(COMPONENT_TYPE)||','||trim(COMPONENT_NAME)||','||trim(SETTING_NAME)||','||rtrim(SETTING_VALUE) from AR_System_Configuration_Co3268;

               6. Disable the file redirection by setting Spool off:
                        spool off;

               7. Remove the top line and bottom line of the resulting CSV file before opening in Excel.