Export DB Users using DBATools

ExportDBUsers.ps1

$ServerName = "Myserver.mydomain.co.uk"

$OutputPath = "G:\Backups\SRV01Users\"

$Dt = Get-Date -f yyyyMMdd #-hhmmss

$Databases = Get-DbaDatabase -sqlinstance localhost 

$Counter = 1
$DBCount = $Databases.Count

foreach($Database in $Databases) {
    $DatabaseName = $Database.Name    
    $Filename = $OutputPath + $dt+"_"+$DatabaseName+".sql"    
    Write-Host "Exporting users for DB: $DatabaseName [$Counter of $DBCount]"  -ForegroundColor Green
    Write-Host "To file: $Filename..." -ForegroundColor Green
    $Database | Export-DbaUser -Filepath $Filename
    $Counter++    
    # Export-DbaUser -SQLInstance $ServerName -Database $DatabaseName -Filepath $Filename   
}

$Filename = $OutputPath + $dt +"_"+$ServerName+".sql"

Write-Host "Exporting users for all databases on: $ServerName" -ForegroundColor Green
Write-Host "To file: $Filename..." -ForegroundColor Green

Export-DbaUser -SQLInstance $ServerName -Filepath $Filename