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

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Jun 30, 2020
Version 8Show Document
  • View in full screen mode

Article Content

Article Number000027912
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: All
IssueThe 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.
 
ResolutionFrom 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

 

Attachments

    Outcomes