Clarity Audit Trial data not being available in Data Warehouse

book

Article ID: 198229

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

There are many Clarity objects and attributes marked for inclusion in the Clarity Data Warehouse database, however we are not able to see the Clarity Audit Trial data in the Data Warehouse. Can the Clarity Global Audit Trail data be included in the data warehouse and marked for audit trail?

Environment

CLARITY SAAS AND ON-PREMISE APPLICATION

Resolution

The Data Warehouse database does not store the Clarity Audit Trial data. The Data Warehouse was not designed with this in mind. If you would like to query the Clarity Audit Trail data in the Clarity database for reporting purpose, you can create a Clarity portlet and query the cmn_audit table.

Searched the Broadcom Communities and found the following information on this topic:
https://community.broadcom.com/communities/community-home/digestviewer/viewthread?MID=823407#bm0af2511d-c17a-49bc-aca8-4edb8b8c1354

https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?MessageKey=8e4f9c25-3ae0-470c-856a-0fffb21bf3be&CommunityKey=7f0cbca3-5f93-4d44-a369-1a8ce98f5578&tab=digestviewer#bm8e4f9c25-3ae0-470c-856a-0fffb21bf3be

https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?MessageKey=bb35578b-21dd-49cf-a4cd-dea672d582b7&CommunityKey=7f0cbca3-5f93-4d44-a369-1a8ce98f5578&tab=digestviewer#bmbb35578b-21dd-49cf-a4cd-dea672d582b7