PowerShell script to get details of SQL Server instances

Following is the PowerShell script to list details of SQL Instances installed on a host. It gets details of even 32 bit installed on 64 bit host.

Following is the script:

$ComputerName=get-content env:computername
$sqlInstLst = @()
echo $ComputerName
$RegPath = 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL'
if (Test-Path $RegPath){

     try{
         Get-ItemProperty -Path $RegPath
     }
    catch{
          Write-Error $_.Exception.Message
          return $false
    }
}
else{
     echo $ComputerName+'does not have SQL Server installed'
}

$RegPath = 'HKLM:\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\Instance Names\SQL'
if (Test-Path $RegPath){
     echo '32 bit instances on'+$ComputerName
     try{
          Get-ItemProperty -Path $RegPath
     }
    catch{
          Write-Error $_.Exception.Message
          return $false
     }
}
else{
     echo $ComputerName' does not have 32 bit SQL Server installed'
}




Comments

Make Money from Surveys

Popular posts from this blog

The current master key cannot be decrypted

Schema.Object has an unresolved reference to Schema

Remove dateModified related warning appearing during Structured data testing