Get SSAS version with Powershell and AMO

  • Article

I will try to illustrate how to get various information about Analysis Services by using powershell.

You could find below the first script to make the first connection:

 

$serverName = "serverName\SQL2008_InstanceName"

# Load the AMO assembly in Powershell
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices")

# Create a server object :
$serverAS = New-Object Microsoft.AnalysisServices.Server

# Connect to your Analysis Services server
$serverAS.connect($serverName)

# Select the information
$serverAS | SELECT  Name,Edition,Version

 

Michel Degremont | Premier Field Engineer - SQL Server Core Engineer |