Extract data from multiple XML files, composing into PSCustomObjects which can then be sorted uniquely.

parse-xml.ps1

# ls *.xml | % {[xml] $xml = cat $_; $xml.Cloud["Cloud.Tabls"].Tables.CloudTable | % { [PSCustomObject] @{ Server = $_["CloudTable.ConnectionProperties"].SqlServerConnectionProperties.Server; Database = $_["CloudTable.ConnectionProperties"].SqlServerConnectionProperties.Database}}}

ls .\*.xml `                                                                    
  | % {[xml] $xml = cat $_;   # Cast to [xml] magically parses XML text into an XmlElement (document).  
  # $xml | gm                 # Then you just have to navigate the various children and attributes.
  $xml.Cloud["Cloud.Tables"].Tables.CloudTable `                                                 
    | % {                                                                                        
      # $_ | gm                                                                                  
      [PSCustomObject] @{     # Cast to [PSCustomObject] "magically" turns a hash into an object w/hash key-value pairs as properties.
        Server = $_["CloudTable.ConnectionProperties"].SqlServerConnectionProperties.Server;     
        Database = $_["CloudTable.ConnectionProperties"].SqlServerConnectionProperties.Database  
      }                                                                                          
    }                                                                                            
  } | sort Server,Database -uniq