000027912 - KB-1600 - How to create an ASR from the linux command line using sql

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000027912
Applies ToAffected Versions: 5.X; 4.2.X
ResolutionNote: This information is only valid for those Aveksa ACM versions (4.2+, 5.+)which include the ASR functionality. For V4.1, please refer to Knowledage base: KB-1504 How to generate an ASR with Aveksa 4.1
To create an ASR from the command line, which writes the .html and .xml to the Linux Filesystem, and does NOT subsequently get listed in the ACM UI on the Diagnostics screen:
1) Login and access the ACM database as avuser and run the following sql 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 filenames will look something like this: 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, (ie, 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 out the location of the AVEKSA_DATA_DIRECTORY by running the following sql 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';
---------- ------------------------ ---------------------------------------------------------------
SYS AVEKSA_DATA_DIRECTORY /home/oracle/AveksaDataDir

To create an ASR that DOES show up in the ACM UI, at Admin->System->Diagnostics:
1) Login and access the ACM database as avuser and run the following sql command:
SQL> execute system_report.run;
After this sql completes, the newly created ASR snapshot should appear on the list of ASR snapshots seen from the UI, under the Admin->System->Diagnostics tab.