If you want to become your boss’ best friend, you need to impress him with great graphics and meaningful diagrams :). One way to achieve this goal is using the Service Manager Dashboard. It is based on SharePoint and can be used to visualize Information from the Service Manager Data Warehouse.
I used to install the WSS3.0 directly on the Service Manager Management Server. Sure, that is not a best practice, but it’s OK for testing purposes. I chose “Basic” and installed everything using the default values.
The wizard to configure the WSS will automatically be started when the Installation finished successfully. It takes some minutes to configure WSS completely. Afterwards, the platform is ready and can be used to integrate the Service Manager Dashboard. Check if the new website works as expected by connecting to WSS.
Now it’s time to start the Installation of the Dashboard. First, some credentials are needed as well as the Servername (and maybe the Instance name) where the Data Warehouse is hosted. The correct Database we need for the Dashboard is the “DWDataMart”.
Next, we need to select the Site owner and the related mail address. To store information from the Dashboard, a new database needs to be created in an existing SQL Instance. In this example i chose the same Instance where the ServiceManager-Database is stored. As a last step, a URL/Port combination is needed to connect to the Dashboard later.
After the installation is successfully done, the Dashboard is accessible by using the configured URL. Different menus and webparts display information about Incidents, Change Requests and Activities. Everything is customizable the way you need it. Make sure to configure the date/time filter of the different webparts so that all needed information is displayed. Here are some impressions …
You can edit, arrange and remove the different webparts so that only the relevant pieces of information are displayed on the portal.
The presented Screenshots do not contain lots of information because they have been taken in a test environment with very few data, but the Dashboard will indeed provide very valuable information in your environment. Give it a try …