This article explains how to check the metadata shell version by running SQL against the metadata in MicroStrategy DB Query Tool?
In certain senarios, it is helpful to find out the metadata shell version by running SQL against the metadata in Strategy DB Query Tool (or ODBC Test Tool in version 8.1.x). Follow steps below to achieve this:
Connect the the metadata DSN from DB Query Tool.
Run following SQL:
Sql SELECT * FROM DSSMDSYSPROP;
Check the Version value for column PROP_VAL. If it is 7.0, it means the metadata version is 8.1.x or 9.0.0 as shown below:
If the Version value for column PROP_VAL is 9010, it means the metadata version is 901 or higher as shown below:
