How to know the last use of all schemas | Community
Skip to main content
April 17, 2023
Solved

How to know the last use of all schemas

  • April 17, 2023
  • 1 reply
  • 705 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Craig_Thonis

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

 

1 reply

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
Adobe Employee
April 18, 2023

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