Q: How can I get a list of available SSAS databases using DMVs?
User Rating: / 1
PoorBest 
Written by Vidas Matelis   
Tuesday, 20 January 2009 02:47

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_NAMEDESCRIPTIONROLESDATE_MODIFIED
Adventure Works DWA Unified Dimensional Model that encompasses the Adventure Works data warehouse.  27/11/2008 2:35:29 AM
Adventure Works DW 2008A 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.

 

Tags: 2008, dmv, faq
 

XL Cubed