Report Portal

List all objects of a SSAS database with time stamps

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.


Tags: amo, script, powershell


2007-2015 VidasSoft Systems Inc.