hand over switches in a variable for cmdlet get-dbadatabase

Question

Hi,
Is there a way to hand over the switches "Database" and "ExcludeDatabase" in a variable to get-DbaDatabase?

The following does not work:
$Instance = 'localhost'
$SelectedDatabases = 'master','model','msdb','tempdb'
$ExcludeOrIncludeDBs = 'ExcludeDatabase'
$Databases = Get-DbaDatabase -SqlInstance $Instance -$ExcludeOrIncludeDBs $SelectedDatabases | foreach {$_.Name}

Instead a login window appears and Username shows "-ExcludeDatabase"

BR
Julian

Answer 1

That's possible if your 3rd-party software allows the use of "splatting" to provide the parameters and switches to that cmdlet.

Try it this way. If it works, that's great. If it doesn't, contact the company supplying the package and request an improvement.

$Instance = 'localhost'
$SelectedDatabases = 'master','model','msdb','tempdb'
$props = @{
    SqlInstance = $Instance
    ExcludeDatabase = $SelectedDatabases
}
$Databases = Get-DbaDatabase @props | foreach {$_.Name}