How to know the last use of all schemas | Adobe Higher Education
Skip to main content
April 17, 2023
해결됨

How to know the last use of all schemas

  • April 17, 2023
  • 1 답변
  • 705 조회

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

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 답변

Craig_Thonis
Adobe Employee
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