#Objective: To get properties of the given Analysis Server #Created by: MAK #Create Date: 9/9/2007 param ([string] $Servername) ## Add the AMO namespace [Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") >$NULL $server = New-Object Microsoft.AnalysisServices.Server $server.connect($ServerName) if ($server.name -eq $null) { Write-Output ("Server '{0}' not found" -f $ServerName) break } else { Write-host "Connection String = " $server.ConnectionString Write-host "Edition = " $server.Edition Write-host "Version = " $server.version Write-host "SessionID = " $server.SessionID Write-host "Assemblies = " $server.Assemblies Write-host "CreatedTimestamp = " $server.CreatedTimeStamp Write-host "LastSchemaUpdate = " $server.LastSchemaUpdate Write-host "Roles = " $server.Roles Write-host "Connected = " $server.Connected Write-host "SessionID = " $server.SessionID Write-host "Databases = " $server.databases }