IT Geeks who will assist you with Research and Development. We build the scenario and test it and give feedback
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)
Labels:
MicroStrategy,
MicroStrategy metadata,
mysql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment