|Applies To||RSA Product Set: Identity Governance and Lifecycle|
RSA Product/Service Type: Appliance
RSA Version/Condition: 6.9.1 and later versions
O/S Version: Linux
|Issue||There isn't a way to delete report templates from the user interface. This article provides steps on how to remove report templates.|
|Resolution||Note: You need to login as the oracle user via an SSH session and execute SQL*Plus commands as the avuser to complete the steps below, or log into the database from SQL Developer.|
SELECT REPORT_NAME, TEMPLATE_ID FROM T_AV_REPORTS WHERE REPORT_NAME='<report name which uses the template to be deleted>'
SELECT ID, report_name FROM T_AV_REPORTS WHERE template_ID='<template ID captured above>'