Searching the script field(s) of workflow activities

[Michael Domke]

Is there a way to search the various script fields in workflow activities? I need to verify the use of certain table/field uses in workflow activity scripts.

For example, search all workflow activity scripts to see which ones contain "u_software" somewhere in the script. To do this manually will be very time consuming as well as the potential for blurry eyed oversight mistakes.

Thanks,
Michael

[Lisa Harley1]

Awesome script!  I added to the query within wf_activity to get just the published records:

var keyword = 'PROVIDE_YOUR_KEYWORD';
var query = 'valueLIKE'+keyword;
var arr = [];
var tbl = new GlideRecord('sys_variable_value');
tbl.addEncodedQuery(query);
tbl.query();
while(tbl.next()){
var wftbl = new GlideRecord('wf_activity');
wftbl.addQuery('sys_id', tbl.document_key);
wftbl.addQuery('workflow_version.published','true');
wftbl.query();
if(wftbl.next()){
arr.push(wftbl.workflow_version.name+' Activity: ' + tbl.document_key.name);
}
}
arr.sort();
for(i=0; i< arr.length; i++){
gs.print(arr[i]);
}

[pankajdesh]

I am looking for a solution to replace Twillio and use some free application to send sms on mobile phones. Please suggest me of you know any.

[sach1]

Companies can purchase SMS subscriptions from Mobile Network providers. They expose REST API's using which you can send SMS. Free application won't be a good idea as you need to use employee's contact numbers as well message will contain some organization data.

[Michael Domke]

This question is no consistent with this thread. I would suggest posting this question outside this thread. You may get more exposure to your question.