Sample Header Ad - 728x90

How do I tell which Edition and Version my SSAS Instance is running?

2 votes
2 answers
8183 views
In SQL Server on the database engine, you can run a SQL query like this to get the server's version info like Edition and Version, and Update Level, etc. SELECT @@VERSION What is the MDX equivalent for querying an SSAS (Tabular or Multidimensional) instance? Are there SSAS DMVs that can get me this answer? I browsed the Books Online page for SSAS DMVs , but I didn't notice any DMVs that could help me. DISCOVER_INSTANCES didn't seem to have the info. Let's assume that SQL Server Database Engine is not installed on this same server as the SSAS instance, so I cannot check this by querying the database engine. In my case, this is for a SQL 2012 Tabular instance, but would like to know how to query Multidimensional instance too.
Asked by John G Hohengarten (674 rep)
May 2, 2016, 04:30 PM
Last activity: Feb 24, 2023, 03:12 PM