When you open the info sheet (the overview) of a script in Designer you can see the Parameters where the script is used. From there you can navigate to the relevant paramater and then to the process.
Or you can use this statement to determine the process and the job which calls the script:
jc.Name as 'Process',
j.Name as 'Job'
from JobChain jc
join Job j on jc.UID_JobChain = j.UID_JobChain
join JobRunParameter jrp on j.UID_Job = jrp.UID_Job
jrp.ValueTemplate like '%VI_BuildPwdMessage%'
order by 1,2
General advice to search for a specific string in all VB code in the database:
You can use the SQL procedure "vid_VBScriptFind".
- Define the search string as a parameter for the procedure. It goes through all columns that contain VB code and searches for the given string.
For the actual search you can execute this statement (please switch to output to "as text", not "as grid"):
exec vid_VBScriptFind 'VI_BuildPwdMessage'