Solved

script using amo to detect informations about Analysis Services

Posted on 2012-03-26
1
422 Views
Last Modified: 2016-02-15
Hello,

I search a script using amo to detect informations about Analysis Services.

Thanks

Regards

bibi
0
Comment
Question by:bibi92
1 Comment
 
LVL 10

Accepted Solution

by:
JoeKlimis earned 500 total points
ID: 37766713
Hi what information are you looking for  ?

The following is an example of the server information


run this on the SQL server

#Step 1 Load the AMO Objects

[reflection.assembly]::loadwithPartialname("Microsoft.AnalysisServices")

#Step 2  access the SSAS instance

$Myserver = New-Object Microsoft.AnalysisServices.server
$MyServer.connect("LocalHost")

#Step 3 - list details about the server
$MyServer

Open in new window

0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This script can help you clean up your user profile database by comparing profiles to Active Directory users in a particular OU, and removing the profiles that don't match.
The following article is intended as a guide to using PowerShell as a more versatile and reliable form of application detection in SCCM.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

805 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question