Q: How can I get a list of available SSAS databases using DMVs?
Q: How can I get a list of available SSAS databases using DMVs?
A: In SSAS 2008 there is DMV '$SYSTEM.DBSCHEMA_CATALOGS' that contains a list of databases. Sample query:
SELECT [CATALOG_NAME], [DESCRIPTION], ROLES, [DATE_MODIFIED]
FROM $SYSTEM.DBSCHEMA_CATALOGS
Result of this query on my laptop:
CATALOG_NAME DESCRIPTION ROLES DATE_MODIFIED Adventure Works DW A Unified Dimensional Model that encompasses the Adventure Works data warehouse. 27/11/2008 2:35:29 AM Adventure Works DW 2008 A Unified Dimensional Model that encompasses the Adventure Works data warehouse. * 11/01/2009 3:42:05 AM TSSUG_AS1 12/11/2008 2:41:02 AM
Done.