I create a script that could help you to find which automation using a specific Data Extension as Target Data Extension in its activities.
To use this:
1. Downloads the script.js
2. Create a new Cloud pages in Classic Editor:
a. web studio > cloud pages
b. Create a new collection if you haven't
c. Open the collection
d. Create new landing page
e. Insert a name and select "Classic Editor" as editor
f. next, and select "code view"
3. In the Cloud page editor copy and paste the code (from script.js file)
4. In the script you can find this row:
* TARGETDE = "matched_profiles" *
change matched_profiles with your target DE name to search its.
5. Now simply Click "preview" to see the results of the search
The script could take some times in order to how many SQL activities and Automation you have in your MC accounts.
But if the preview load a lot of time could be a problem with syntax (error 500), try to save and publish the page and go to the url to view if 500 error is provided.
If you have more then 2500 activities (using your target DE) the Script return an incomplete search.
The Script have a LOG system that told you if something gone wrong.
Regards,
Simone
That's great!
I develop this approach to be easiest as possibile using a step-by-step procedure.
It's based on SSJS but simply makes API requests and parse the results, so, an other approach is by using the same API with an other provider (external or internal).
Any way, other methods are welcome (maybe without API usage, could be great!) but I don't think there are so many, Marketing Cloud haven't a "search by properties" feature in Automation Activities so really can't imagin how can approach this goal in a different way.
Regards,
Simone
