public/Get-AnalysisServicesDeploymentExePath.ps1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
function Get-AnalysisServicesDeploymentExePath {
<#
    .SYNOPSIS
    Find path to specific version of Microsoft.AnalysisServices.Deployment.exe
 
    .DESCRIPTION
    Finds the path to specific version of Microsoft.AnalysisServices.Deployment.exe
    Checks the following locations:
     
        ${env:ProgramFiles(x86)}\Microsoft SQL Server\*\Tools\Binn
        ${env:ProgramFiles(x86)}\Microsoft SQL Server Management Studio *\Common7\IDE
        $env:CustomAsDwInstallLocation
     
    The environment variable $env:CustomAsDwInstallLocation allows you to specify your own custom install directory.
 
    .PARAMETER Version
    The version of Microsoft.AnalysisServices.Deployment.exe to find.
    Valid values for -Version are: ('15', '14', '13', '12', '11') which translate as follows:
     
    * 15: SQL Server 2019
    * 14: SQL Server 2017
    * 13: SQL Server 2016
    * 12: SQL Server 2014
    * 11: SQL Server 2012
     
    If you are unsure which version(s) of Microsoft.AnalysisServices.Deployment.exe you have installed, use the function **Find-AnalysisServicesDeploymentExeLocations** to obtain a full list.
 
    .EXAMPLE
    Get-AnalysisServicesDeploymentExePath -Version 15
 
    Returns the SQL Server 2019 version of Microsoft.AnalysisServices.Deployment.exe (if present on the machine).
 
    .EXAMPLE
    Get-AnalysisServicesDeploymentExePath -Version 14
 
    Returns the SQL Server 2017 version of Microsoft.AnalysisServices.Deployment.exe (if present on the machine).
 
    .OUTPUTS
    Returns a string containing the full path to the selected version of Microsoft.AnalysisServices.Deployment.exe
 
    .LINK
    https://github.com/DrJohnT/DeployCube
 
    .NOTES
    Written by (c) Dr. John Tunnicliffe, 2019-2021 https://github.com/DrJohnT/DeployCube
    This PowerShell script is released under the MIT license http://www.opensource.org/licenses/MIT
#>

    [OutputType([string])]
    [CmdletBinding()]
    param(
        [Parameter(Mandatory = $true)]
        [ValidateNotNullOrEmpty()]
        [ValidateSet('15', '14', '13', '12', '11')]
        [string]$Version
    )

    [string] $ExeName = "Microsoft.AnalysisServices.Deployment.exe";
    [string] $AnalysisServicesDeploymentExePath = $null;
    
    # Location SQL Server 2017 and prior
    [System.IO.FileSystemInfo[]]$AnalysisServicesDeploymentExes = Get-Childitem -Path "${env:ProgramFiles(x86)}\Microsoft SQL Server\*\Tools\Binn" -Recurse -Include $ExeName -ErrorAction SilentlyContinue;

    # Location SQL Server 2019 and greater (i.e. installed with SSMS)
    $AnalysisServicesDeploymentExes += Get-Childitem -Path "${env:ProgramFiles(x86)}\Microsoft SQL Server Management Studio *\Common7\IDE" -Recurse -Include $ExeName -ErrorAction SilentlyContinue;

    # Custom install location defined by Environment variable CustomAsDwInstallLocation
    $CustomAsDwInstallLocation = [Environment]::GetEnvironmentVariable('CustomAsDwInstallLocation');
    if ("$CustomAsDwInstallLocation" -ne "") {
        if (Test-Path $CustomAsDwInstallLocation) {
            $AnalysisServicesDeploymentExes += Get-Childitem -Path "$CustomAsDwInstallLocation\" -Recurse -Include $ExeName -ErrorAction SilentlyContinue;
        } else {
            throw "Invalid custom environment variable path: CustomAsDwInstallLocation";
        }        
    }

    foreach ($AnalysisServicesDeploymentExe in $AnalysisServicesDeploymentExes) {
        $ExePath = $AnalysisServicesDeploymentExe.FullName;
        [string] $ProductVersion = $AnalysisServicesDeploymentExe.VersionInfo.ProductVersion.SubString(0,2);
       
        if ($ProductVersion -eq $Version) {
            $AnalysisServicesDeploymentExePath = $ExePath;
            Write-Verbose "$ExeName version $Version found here: $AnalysisServicesDeploymentExePath";       
            break;
        }            
    }
    return $AnalysisServicesDeploymentExePath;
}