October 1, 2013 at 8:32 pm
Not sure if this is the correct place to post this but I am looking to see if there is any where I can get a listing of objects on a SSAS database and at the very least a last changed date and or created date? I know on the database engine in the master database the SysObjects table has this information for each database on the server. Does anyone know where something like this is in an SSAS database? any help is greatly appreciated.
October 2, 2013 at 5:57 am
Just like the DB Engine, SSAS contains several DMV's you can query for this kind of data.
As a starter open a DMX Query window and run:
SELECT * FROM $System.DBSCHEMA_CATALOGS
SELECT * FROM $System.DBSCHEMA_TABLES
For more information about SSAS DMV's see http://msdn.microsoft.com/en-us/library/hh230820.aspx
[font="Verdana"]Markus Bohse[/font]
October 5, 2013 at 2:25 pm
Awesome, thanks Markus. I will check that out
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply