Ahoy,
i have few ssas server instances and many tabular models on each of the server.
Now i want to gather structural metadata of these models.
There are some DMVs which seem to get what i need:
But the problem seems to be that these DVMs can not get data across multiple models/databases.
When executed against the server its only running against the default database.
What i need is a way to get the information from all the databases.
The name of the databases can easily be aquired with the following DMV:
select *
from $SYSTEM.DBSCHEMA_CATALOGS
Now i need a way to run the same 3 DMVs from above against the list of databases.
I want to be the very best
Like no one ever was
Ok found solution to my own question, using SSIS
1 Import all relevanten Database names
select *
from $SYSTEM.DBSCHEMA_CATALOGS
2 Use a loop container to edit the connection string and replace the database name for each execution
I want to be the very best
Like no one ever was
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy