How to know the last use of all schemas

[Arthur_LEBRIS]

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

[Craig_Thonis · Accepted solution]

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