$sqlServerRoot='Registry::HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server'
if (Test-Path "$sqlServerRoot\Instance Names\SQL")
{
    $inst=Get-Item -Path "$sqlServerRoot\Instance Names\SQL" | select -ExpandProperty Property
    foreach ($i in $inst)
    {
    $instance_name=(Get-ItemProperty "$sqlServerRoot\Instance Names\SQL").$i
    $instance_name
    (Get-ItemProperty "$sqlServerRoot\$instance_name\Setup").Edition
    (Get-ItemProperty "$sqlServerRoot\$instance_name\Setup").PatchLevel
    }
}
if (Test-Path "$sqlServerRoot\Instance Names\OLAP")
{
    $inst=Get-Item -Path "$sqlServerRoot\Instance Names\OLAP" | select -ExpandProperty Property
    foreach ($i in $inst)
    {
    $instance_name=(Get-ItemProperty "$sqlServerRoot\Instance Names\OLAP").$i
    $instance_name
    (Get-ItemProperty "$sqlServerRoot\$instance_name\Setup").Edition
    (Get-ItemProperty "$sqlServerRoot\$instance_name\Setup").PatchLevel
    }
}
if (Test-Path "$sqlServerRoot\Instance Names\RS")
{
    $inst=Get-Item -Path "$sqlServerRoot\Instance Names\RS" | select -ExpandProperty Property
    foreach ($i in $inst)
    {
    $instance_name=(Get-ItemProperty "$sqlServerRoot\Instance Names\RS").$i
    $instance_name
    (Get-ItemProperty "$sqlServerRoot\$instance_name\Setup").Edition
    (Get-ItemProperty "$sqlServerRoot\$instance_name\Setup").PatchLevel
    }
}
$verList='90','100','110','120','130','140','150'
foreach ($ver in $verList)
{
    if (Test-Path "$sqlServerRoot\$ver\DTS\Setup") 
    {
        "MsDtsServer$ver"
        (get-itemproperty "$sqlServerRoot\$ver\DTS\Setup").Edition
        (get-itemproperty "$sqlServerRoot\$ver\DTS\Setup").PatchLevel
    }
}