How to delete all data in the Identity Reporting Module database

How to delete all data in the Identity Reporting Module database

Recently I had a need to clean up both historic and current data from the Identity Reporting Module database (also known as the Identity Information Warehouse) and start with a fresh database.

In Identity Manager v4.0.2 there is a pretty quick and painless way to do that without resorting to manual SQL scripts.

It's based on the REST API that the Reporting Module provides. Unfortunately it seems that this API isn't documented, at least I couldn't find any information on it.

Here is a step-by-step guide on how to empty your Reporting Module database.

I performed the cleanup using Firefox and an extension called RESTClient.

First you need to get an Authentication token from the Reporting Module using a POST against the URL /IDMRPT-AUTH/auth/tokens with a Basic Authorization header, see the screenshot below.


You will get back a JSON response, you need the TokenDigest value. Copy it.

The next step is to issue a command to clean up the database. To be able to do that you need to stop the data collection in the Reporting Module web interface.

Login to your Reporting Module and navigate to the Identity Vault Data Sources page.

Make sure that the Managed System Gateway Driver is suspended and deselect the "Enable event collection" checkbox.


Next, return to Firefox and RESTClient.

Now we will send a DELETE to the /IDMRPT-CORE/rpt/collectors/data URL using our authentication token that we store in a header called Authorization with the type X-OPAQUE, see the screenshot below.


Check your Reporting Module log for indication that the cleanup has been performed. For example this can be seen in server.log for my Reporting Module that is running on JBoss:

2014-06-04 14:03:25,208 INFO  [STDOUT] (http- INFO  [RPT] [com.novell.idm.rpt.core.server.logging.naudit.LogEvent:logDatCollectionEvent] [Data_Cleanup_Requested] Initiated by cn=uaadmin,o=system; Data Collector UUID ALL

Perform a check using your favorite SQL-browser or use pgAdmin that comes with the Reporting Module to make sure that the database is empty.




Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2014-06-11 19:56
Updated by:
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.