000034708 - How to delete report templates using RSA Identity Governance and Lifecycle

1. Find the ID of the report template:

SELECT REPORT_NAME, TEMPLATE_ID FROM T_AV_REPORTS WHERE REPORT_NAME='<report name which uses the template to be deleted>'

2. Find the IDs of any reports that use the template ID captured above:

SELECT ID, report_name FROM T_AV_REPORTS WHERE template_ID='<template ID captured above>'

3. Login to the UI to delete any report results that were created using the template identified in step 2.  
4. Navigate to Reports > Tabular.
5. Select the report(s) to be deleted.  Scroll down the page to find the saved results in the table.  
6. Click Delete to delete the saved results of the report.

4. When you fetch the ID of the template in step 1, pick any report and click on it without editing it, according to the template type you saved (if you want to delete a template saved from a tabular report, pick any tabular report), and switch the OID in the URL with the fetched id of the template. The following is an example of a URL which shows the OID to replace with the template ID:

5. When the modified URL is accessed, you will be directed to a page similar to the report page having the name of the report template.
6. There will be a delete icon on the right side of the page which will delete the template.