This PowerShell script connects to a specified list of Servers and pulls all users that exist under a provided database role. This is useful for auditing your SQL environment. This was written under the old sqlps module, but will still work without issue in the new sqlServer PowerShell module. The example uses the SSISDB ssis_admin role but can be modified as needed. For full details on how to use this script, check out the full post at https://blogs.msdn.microsoft.com/sql_pfe_blog/2016/06/29//

https://blogs.msdn.microsoft.com/sql_pfe_blog/2016/06/29//