Log in  \/ 
x
x
x
Register  \/ 
x

02
June
2015

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.

screenshot1

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.

Download the script

Categories: System Center 2012, System Center 2012 Service Manager, SCUTILS BLOG

Marat Kuanyshev

Leave a comment

You are commenting as guest.

This is the default dialog which is useful for displaying information. The dialog window can be moved, resized and closed with the 'x' icon.