title: Idea for finding the SQL Server instances using Powershell Script
body: <p>Description: I have one window server in which different versions of MS SQL servers are running and when I ran below power shell script it displays below result but I need to add SQL Server version like with name as SQL Server 2014, SQL Server 2008 ...</p>
  
  <p>I am running below PowerShell script to get the details</p>
  
  <pre><code>[System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources()
  </code></pre>
  
  <p>PowerShell script output:</p>
  
  <pre><code>ServerName          InstanceName         IsClustered       Version
  ----------          ------------         -----------       -------------
  hostname1                                   No             11.0.3000.0
  hostname2           RAMTEST                 No             11.0.3000.0
  </code></pre>
  
  <p>I need to add one more column with SQL Server name based on version. Please suggest</p>