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 Jun 7, 2019
Version 4Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000027912
Applies ToRSA Product Set: Identity Governance & Lifecycle
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 knowledge 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