Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Tracking/Audit of Changes made in Adobe Campaign Web Application

Avatar

Level 2

Is it possible to track and audit changes made in Web Application / Form in Adobe Campaign Classic? I see and Audit option for Workflows, Schemas and Options but not for Web Applications.

If not - has anybody implemented any custom solution for this?

 

1 Accepted Solution

Avatar

Correct answer by
Employee

Hi @RadAndric ,

 

The Last-Modified field of web-app changes once a web-app is saved after any modification. The Modified By field also changes with the mapping of the Operator who changed the web-app.

If I were to track this, I would create a new schema with fields > Modification Date Time, Modified By, and Web-App ID

This schema will be 1-N mapped from the web-app schema and 1-N mapped from the operator table.

Now I would create a new workflow with a scheduler, query, and update data activity. The query runs on the web-app schema and pulls all the web-apps with a primary key greater than 0. Pass the web-app ID, modified by and the last modified fields downstream the workflow. In the update data, use reconciliation on web-app ID and last modification date time with the new schema that you created. The idea is, if the last modified date time and web-app id do not reconcile with any entry of the new schema, that means it's either a new web-app or an old web-app that has been modified. In case of no reconciliation, this will create a new entry in the new schema with the web-app ID, last modified date time, and the modified by data that comes from the query.

 

Since the web-app table is not a big table, you can schedule this workflow to run every 5 minutes to track changes in the web-app table.

 

Note: The workflow needs to execute at least once before the above logic becomes helpful. Basically to fill the new schema with the current web-app table data. In the next execution, it can track changes.

 

Regards,

Shivam

View solution in original post

1 Reply

Avatar

Correct answer by
Employee

Hi @RadAndric ,

 

The Last-Modified field of web-app changes once a web-app is saved after any modification. The Modified By field also changes with the mapping of the Operator who changed the web-app.

If I were to track this, I would create a new schema with fields > Modification Date Time, Modified By, and Web-App ID

This schema will be 1-N mapped from the web-app schema and 1-N mapped from the operator table.

Now I would create a new workflow with a scheduler, query, and update data activity. The query runs on the web-app schema and pulls all the web-apps with a primary key greater than 0. Pass the web-app ID, modified by and the last modified fields downstream the workflow. In the update data, use reconciliation on web-app ID and last modification date time with the new schema that you created. The idea is, if the last modified date time and web-app id do not reconcile with any entry of the new schema, that means it's either a new web-app or an old web-app that has been modified. In case of no reconciliation, this will create a new entry in the new schema with the web-app ID, last modified date time, and the modified by data that comes from the query.

 

Since the web-app table is not a big table, you can schedule this workflow to run every 5 minutes to track changes in the web-app table.

 

Note: The workflow needs to execute at least once before the above logic becomes helpful. Basically to fill the new schema with the current web-app table data. In the next execution, it can track changes.

 

Regards,

Shivam