I want to retrieve the existing connection string from SSAS for each OLAP Cube or Database. The data will be used in a control/audit report.
I've found that Powershell allows me to drill into SSAS like a directory and I can see what I'm after, but don't know how to query it.
in Powershell I can drill down to here:
PS SQLSERVER:\SQLAS\LAP123\Default\databases\EnvironmentalAnalysisService\Datasources>
And I can see the details I want:
Name Isolation Max Connections Connection String
---- --------- --------------- -----------------
Environmental Data Mart ReadCommitted 10 Provider=SQLNCLI11.1;Data
Source=LAP123;Integrated
Security=SSPI;Initial
Catalog=EnvironmentalDataMart
In this case Server; LAP123 & Database: EnvironmentalDataMart
How can I get the items I want from Powershell like a query?
Best Answer
Woohoo!!!
returns: