May 22, 2012 at 1:38 pm
I need to create some documentation on the SSAS presence on our servers. I have 240+ instances, all ranging from SQL 2000 - 2008 R2. I need to create a method to search for installations of SSAS, and their corresponding databases. I am a complete newb when it comes to SSAS so any help I can get here would be amazing!
May 22, 2012 at 5:30 pm
First you could iterate through the list of servers and query the services trying to find SSAS service on each (http://stackoverflow.com/questions/842533/in-c-sharp-how-do-i-query-the-list-of-running-services-on-a-windows-server).
After that you iterate through the list of servers with SSAS installed and create a list of databases (http://social.msdn.microsoft.com/Forums/en/sqlanalysisservices/thread/d4a79b8e-785a-45e8-88d2-c93d9f5cf3f1)
Regards
May 23, 2012 at 7:36 am
I can iterate through the instances with no problem using an SSIS package, is there any easy way to query the existence on an SSAS installation. The linked code examples give undesired results. I do not need a list of services,( although that link has been saved for future reference ), just affirmation of the existence of SSAS. I can flag that server name in output, and then search for the related databases. Thanks for the reply btw.
May 23, 2012 at 9:11 am
If you find the SSAS Service in the list it means SSAS is installed on the box.
May 23, 2012 at 10:11 am
I see, thank you
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply