Powershell connecting to multiple instances

• SQLAssAS

  SSCertifiable

  Points: 7246

  More actions

  August 15, 2017 at 9:35 am

  #332203

  I am new to Powershell and I am currently trying to figure out why the below is not returning the server\instance as part of the script. I am guessing its because of the named instance and the '\'

  It is returning the other info, just not the server\instance
  ---------------------------

  $instances = @('Server1\Instance1','Server1\instance2')

  $instances | ForEach-Object {get-childitem "SQLSERVER:\SQL\$_\databases" -Force} |
  Sort-Object size -descending |
  Select-Object @{n='Server';e={$_parent.Name}},name,lastbackupdate,size

  --------------------------------------

• Tom_Hogan

  Hall of Fame

  Points: 3942

  More actions

  August 15, 2017 at 11:37 am

  #1955327

  I believe it's because you're trying to apply a method to a property.  This should work

  
$instances = @('Server1\Instance1','Server1\Instance2')

  $instances |
  ForEach-Object {Get-ChildItem "SQLSERVER:\SQL\$_\databases" -Force} |
  Sort-Object Size -Descending |
  Select-Object @{n='Server';e={$_.parent}}, name, lastbackupdate, size

• SQLAssAS

  SSCertifiable

  Points: 7246

  More actions

  August 16, 2017 at 4:27 am

  #1955423

  much appreciated - that works!