Best way to search run powershell activity in orchestration workflows

[Mollie V]

Hello all,

I have been tasked with searching everywhere the 'Run PowerShell' workflow activity is used. Apart from looking at every single workflow and flow available, is there an easier way to search? I tried using Code Search in Studio but that is not returning helpful results.

Any insight and support is much appreciated.

Mollie

[James Chun]

Hi @Mollie V,

I think you can check the Workflow Activities [wf_activity] table.

For your case, you can search the 'Activity definition' field with 'Run PowerShell'.

Note that this is only for Workflow only, workflow activity cannot be used with Flow.

Cheers

[Mollie V · Accepted solution]

Hi @James Chun - I think that works. I queried the wf_activity table and see the Run Powershell activity with the workflow name. Thank you.

[IbrahimK4837164]

Hello Molly! Try typing the keywords from your "Launch PowerShell" action into the search box in Studio. Make sure you select the "Search All Files" option to take into account all projects. If you have the ability to view output or logs after running workflows, you can check to see if there is any mention of PowerShell being used.

[Mollie V]

Thanks Ibrahim, I will try and post here my findings.