Teamcenter Audit_purge Utility not working for Event type

2022-08-08T09:59:06Z
Core Functions

Summary


Details

We are trying to purge the audit logs for the eventtype

But the given utility in the documentation is not working for the specific Even type

It is asking for the log type as mentioned below for

1. audit_purge -u=username -p=password -g=group -created_after=19-JAN-2020 12:00 -created_before=21-JAN-2020 12:00 -eventtype=__Add_Attachment -purge

2. audit_purge –u=dcproxy -p=dcproxy -g=dba -eventtype=__Check_in

"Arguments -logtype and -purge or -archive are mandatory. Please provide logtype with either -purge or -archive flags"

Could you please help us to purge the audit logs for the specific event type?

Solution

The event type of Check_In and Check_out are stored in the table PFND0GENERALAUDIT.

You can check this simply executing the following SQL query after the checkin operation

SELECT COUNT(*) FROM PFND0GENERALAUDIT;
So the correct arguments for the audit_purge utility should be :
audit_purge -u=infodba -p=infodba -g=dba -logtype=FNd0GeneralAudit -retentionperiod=90 -eventtype=__Check_In -purge

KB Article ID# PL8664695

Contents

SummaryDetails

Associated Components

Core Functions - Server