How to get the status for cubes and measure groups in SCSM 2012 Data Warehouse
Recently I’ve received an email from our customer who asked for a script to get the status of OLAP cubes and their measure groups without using the SCSM 2012 console or SQL Management Studio. We had some pre-built scripts to work with Microsoft SQL OLAP so the task was accomplished quite easy and fast.
The script requires one parameter: the name of server hosting a database of SCSM Data Warehouse. Please feel free to customize the script to get other information related to OLAP in Microsoft System Center 2012 Service Manager.
Please find the script in the attached archive.