List all objects of a SSAS database with time stamps

Written by Olaf Helper. Posted in SSAS Scripts

This PowerShell script uses the .NET AdoMd client (namespace Microsoft.AnalysisServices.AdomdClient) to connect to a Microsoft Sql Server Anaylsis Services (SSAS) database.

It lists all objects of the database with it's type, name, the last processing and the last update time stamp.

Requieres PowerShell 2.0 and an actuall AdoMd client, which can be downloaded from the latest Microsoft SQL Server Feature Pack.