How to know all workflows referring a particular schema in adobe campaign instance

[Poonam_Dogra]

Hi All,

Is there any direct or related way of fetching the workflows/campaigns where a particular data schema is used either as a link or as a targeting/filtering dimension [any clue which says this data schema is being referred].

Requirement: To fetch the workflows/campaign workflows which have used a particular schema, ex abc:table1. Instead of doing manually which is time consuming, is there a way this can be achieved?  

All I could figure out as of now is to fetch the details from xtk:workflow which have this table in its memo data.. Are there any other possible ways to do the same?

Any related ways will also be very helpful.

Thanks in advance!

[Malarrajan_Sundarraj · Accepted solution]

Hi @Poonam_Dogra ,

Try this way.

- Query the xtk:workflow schema with the below filtering condition 

  Query: XML memo contains 'nms:delivery'

Thanks,

- Malarrajan Sundarraj

[Poonam_Dogra]

Thank you @Malarrajan_Sundarraj , for responding and helping