The powershell script is creating a Firewall rule on a different server. The script runs fine when I execute it in powershell, however when I execute the script via t-SQL...

I am running it against the local SQL Server. I had a feeling it was erroring out because of some credential based rule. I may try breaking the Powershell script...

I don't currently have sufficient permissions to create functions but I might be able to get this in front of someone who can add this. Thanks for the article

The only issue is I don't know the number of Manager names to be selected as it will be based on user defined parameter