000027912 - How to create an Aveksa Statistics Report (ASR) from the Linux command line using SQL in RSA Identity Governance and Lifecycle

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Feb 19, 2018
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000027912
Applies ToRSA Product Set: RSA Identity Governance and  Lifecycle
Affected Versions: 4.2.x,  5,x, 6,x, 7.x
IssueIf the Aveksa Statistics Report (ASR) cannot be run from the UI by clicking Create Report or if it runs by using the Create Report button or is run as a scheduled report, but cannot be downloaded, then this is the command line workaround to generate the ASR that can be downloaded from the UI.
ResolutionTo create an ASR from the command line, which writes the .html and .xml files to the Linux file system, and does NOT subsequently get listed in the ACM UI on the Diagnostics screen:

Login and access the ACM database as AVUSER and run the following command:

SQL> EXECUTE System_Report.save;

  • This will create a date-stamped file in the AVEKSA_DATA_DIRECTORY. It does NOT create an ASR which is displayed in the UI.
  • The generated file names will look something like:
    • Aveksa_Statistics_Report.20120815.155307.html
    • Aveksa_Statistics_Report.20120815.155307.xml
  • The AVEKSA_DATA_DIRECTORY on an appliance is /home/oracle/AveksaDataDir.
On a remote database system, WAS or WL install, (also known as a customer provided database), these files will be located in the directory defined in the database as the AVEKSA_DATA_DIRECTORY.  You can find the location of the AVEKSA_DATA_DIRECTORY by running the following query as AVUSER:

SQL> SET linesize 132
SQL> COL directory_path FORMAT a80;
SQL> COL owner FORMAT a10;
SQL> SELECT * FROM all_directories WHERE directory_name IN 'AVEKSA_DATA_DIRECTORY';

To create an ASR that shows up in the ACM UI,
  1. Navigate to the Admin  > System > Diagnostics tab > Statistics Report section.
  2. Login and access the ACM database as AVUSER and run the following command:

SQL> EXECUTE system_report.Run(null,null,null,null,systimestamp);

Note that using the command above that includes the systimestamp will generate the ASR with a properly timestamped Name and Date in the UI.

After this command completes, the newly created ASR snapshot should appear on the list of ASR snapshots seen from the UI, under the Admin > System > Diagnostics tab.
NotesNote: This information is only valid for those Aveksa ACM versions (i. e., 4.2+, 5.+,6.+,7.+) which include the ASR functionality. For version 4.1, please refer to article 000027938 (Implementing Aveksa Statistics Report (ASR) for Aveksa Compliance Manager (ACM) 4.1.x).