Get SSAS version with Powershell and AMO

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

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

# Connect to your Analysis Services server

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


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



Comments (0)