How to create an Aveksa Statistics Report (ASR) from the linux command line prompt using SQL in RSA Identity Governance & Lifecycle
3 years ago
Originally Published: 2014-10-20
Article Number
000062445
Applies To
RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: All
Issue
The RSA Identity Governance & Lifecycle Aveksa Statistics Report (ASR) provides comprehensive information about your RSA Identity Governance & Lifecycle implementation and is an invaluable tool for troubleshooting a multitude of issues. RSA Identity Governance & Lifecycle Support will frequently request an ASR when working on a support case.

There are two ways to obtain this report: 
  1. Through the RSA Identity Governance & Lifecycle user interface.
  2. At the linux command line prompt.
This article provides steps for obtaining this report from the linux command line for those times when it cannot be run from the RSA Identity Governance & Lifecycle user interface. For instructions on how to obtain the ASR from the RSA Identity Governance & Lifecycle user interface, please see RSA Knowledge Base Article 000033719 - How to create an Aveksa Statistics Report (ASR) in RSA Identity Governance & Lifecycle.
 
Resolution
From the command line, an Aveksa Statistics Report can be generated that will then be available for download in the RSA Identity Governance & Lifecycle user interface.
  1. Login to the RSA Identity Governance & Lifecycle database as avuser.
  2. Execute one of the following commands depending on your RSA Identity Governance & Lifecycle version:
For versions 7.1.0 and earlier:
SQL> EXECUTE system_report.Run(null,null,null,null,systimestamp);
For versions 7.1.1 and 7.2.0:
SQL> EXECUTE system_report.Run(null,null,null,systimestamp);
NOTES:
  • Starting in 7.1.1 there is one less parameter being passed to the system_report PL/SQL package.
  • Using the above command with the systimestamp parameter will generate the ASR with a properly timestamped Name and Date in the user interface.
  1. After this command completes, the newly created ASR snapshot will appear on the list of ASR snapshots seen from the user interface under the Admin > System > Diagnostics tab.
Notes


 

Related Articles

Trending Articles

Don't see what you're looking for?