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

Document created by RSA Customer Support Employee on Jun 14, 2016•Last modified by RSA Customer Support on Apr 15, 2020
Version 6Show Document
  • Comment • 0
  • 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.
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. Run the following command:


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


Note that using the above command that includes 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