Showing posts with label MicroStrategy. Show all posts
Showing posts with label MicroStrategy. Show all posts

Monday, September 17, 2018

MicroStrategy Metadata Version



This is an example of how to tell the version of a metadata backup, using a SQL query:

For MySql:

select
CONCAT((SELECT LEFT(PROP_VAL,2)  FROM DSSMDSYSPROP WHERE `NAME` = 'Version'),'.',(select LEFT(PROP_VAL,2)  FROM DSSMDSYSPROP WHERE `NAME` = 'SCHEMAVERSION')) AS `Schema Version`;

Or SELECT * FROM DSSMDSYSPROP ; (This will show all properties)