public/Ping-SsasServer.ps1
|
function Ping-SsasServer { <# .SYNOPSIS For on-premise SSAS instances only! Checks that the SQL Server SSAS instance exists. .DESCRIPTION For on-premise SSAS instances only! Checks that the SQL Server SSAS instance exists. .PARAMETER Server Name of the SSAS server, including instance and port if required. .EXAMPLE Ping-SsasServer -Server build02; Returns true if server build02 exists and has SSAS installed. .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([Boolean])] [CmdletBinding()] param ( [String] [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] $Server ) if ($Server -like "asazure*") { throw "Azure Analysis Services not supported. Only on-premise servers are supported by Ping-SsasServer"; } try { [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") | Out-Null; $ssasServer = New-Object Microsoft.AnalysisServices.Server; $ssasServer.connect($Server); if ($ssasServer.Connected -eq $false) { return $false; } $ssasServer.disconnect(); return $true; } catch { return $false; } } |