Get d/b connections from Sisense elasticubes

Get-DbConnections.ps1

cd  N:\SisenseBuilds\Elasticubes
ls */*.xml `
   | % {[xml] $xml = cat $_;
     # $xml | gm
     $xml.Cloud["Cloud.Tables"].Tables.CloudTable `
       | % {
         # $_ | gm
         [PSCustomObject] @{
           Server = $_["CloudTable.ConnectionProperties"].SqlServerConnectionProperties.Server;
           Database = $_["CloudTable.ConnectionProperties"].SqlServerConnectionProperties.Database
         }
       }
     } | sort Server,Database -uniq