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)







No comments:

Post a Comment