CODEWITHSUNDEEP
ssas
EitanT
EitanT

Reputation: 305

How do I query all SSAS database connections?

I would like to know for example how many databases in my SSAS has sql connections. Is there a way to query all of them together?

Upvotes: 3

Views: 3938

Answers (1)

Meff
Meff

Reputation: 5999

Have you looked at the SSAS DMVs?

http://msdn.microsoft.com/en-us/library/hh230820.aspx

Just run them in a normal MDX query pane

Select * from $System.discover_sessions

Upvotes: 5

Related Questions