Archived Rule Trail - Database Table

[PRana]

Hi All,

In which database table entries from 'Archived Rule Trail' are stored? We are using v24.1

I am able to retrieve entries from 'Current Rule Trail' from userrulerundata table but unable to find the entries from 'Archived Rule Trail' in that table.

Thanks

[rushikeshvartak · Accepted solution]

Table Name :  userrulerundata_archive

select USERRULERUNDATA_ARCHIVEKEY,BIRTHRIGHT,CHANGEMAP,COMMENTS COMMENT,DETECTIVE,EVENTSOURCE,JOBGROUP,JOBID,NEWDATA,OLDDATA,PARENTJOBID,PROCESSED,RULEACTIONFAILED,RULEACTIONSUCCESSFUL,RULEACTIONTOBEFIRED,RULETYPE,TRAIL,UPDATEDATE UPDATEDAT ,USERHISTORYKEY,USERKEY,USERRULERUNDATAKEY,WSBATCHIDENTIFIER from userrulerundata_archive