List all objects of a SSAS database with time stamps
User Rating: / 0
Written by Olaf Helper   
Thursday, 22 September 2011 17:55

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.




Pyramid Analytics