Improve company productivity with a Business Account.Sign Up

x
?
Solved

script using amo to detect informations about Analysis Services

Posted on 2012-03-26
1
Medium Priority
?
451 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 11

Accepted Solution

by:
Joe Klimis earned 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In an Exchange Crossforest migration, the distribution groups can be a very complex operation that would cause loss of time, lots of issues and continued headaches if not solved in a timely manner. I had to do a similar project so I created a sc…
What is Archiving? Archiving in Exchange Online (called In-Place Archiving) provides users with additional mailbox storage space.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

588 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