Analysis Services Server Version DMV

Recently I discussed with colleagues how to get the Analysis Services Server version in an environment when you are not an OLAP Administrator.

You can run the following code on the OLAP server as an MDX query on any database you have access to …

select [Value] from $system.discover_properties where PropertyName = 'DBMSVersion'

Thanks to DG !

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s