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

Schema.Object has an unresolved reference to Schema

The current master key cannot be decrypted

RDP Issue: The Function requested is not supported