Hi All i have to collect the SSAS properties ("Analysis Server Properties") into a SQL table , i can not find any DMV to get the "Analysis Server Properties" but i am assuming it can be done with PowerShell, can anyone help? I also need the "SSAS Database Properties". bottom...
PowerShell for SQL Server
Filed under: SSIS, PowerShell, SQL Admin, DBA, SQL 2008, SQL, Database, powershell get-sqldata iterate through get-sqldata resultset sqlpsx library, Verify SQL Server services
I second this question, it would be helpful for me as well. I'm also interested in learning how leverage SQL Central Management Server and Powershell.