Expand my Community achievements bar.

SOLVED

How to know the last use of all schemas

Avatar

Level 1

Hello,

I work on an Adobe Campaign with over 200 custom schemas.

Some of them are outdated and unused but I don't know wich ones.

Is there a query to know for each schema when was the last time it was used in a workflow ?

The ideal output would be a table with 2 columns : schema, last usage date.

 

Thank you

 

Arthur

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Hi Arthur,

The only way to determine when the last time a schema was used would be based on the last modified date or based on the most recent record inserted into the table itself. That said, unless a field was added to track the last time it was accessed via a workflow, there isn't a way to determine whether a workflow last updated the schema.

 

Regards,

Craig

 

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

Hi Arthur,

The only way to determine when the last time a schema was used would be based on the last modified date or based on the most recent record inserted into the table itself. That said, unless a field was added to track the last time it was accessed via a workflow, there isn't a way to determine whether a workflow last updated the schema.

 

Regards,

Craig