Adding SCOM 2012 Visio Dashboards into SharePoint 2010

 

In my last blog post, I showed how to create a SCOM Dashboard using Visio.  https://www.scom2k7.com/creating-scom-2012-dashboards-using-visio-2010-or-visio-2013/

 

Now I am going to show how to add this Dashboard into SharePoint 2010.

 

To start I need the Microsoft Visio 2010 and SharePoint 2010 Extensions for System Center 2012 found here.
http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=29268

 

Part 1 – Installing SharePoint 2010 Integration Components

 

Here are the pre-requisites:

  • System Center 2012 – Operations Manager console or Operations Manager 2007 R2 Authoring Console.
  • SharePoint 2010 Enterprise with Visio Services enabled.
  • The Microsoft .NET Framework 3.5 SP1, available from http://go.microsoft.com/fwlink/?LinkID=131605

 

First I install the Operations Manager 2012 SP1 console on my SharePoint Server
image

 

I also verify that the SharePoint 2010 Enterprise with Visio Services are enabled.

 

On my SharePoint server I go to the SharePoint Central Administration Page.

 

I click Configuration Wizards.

image

 

I click Launch Farm Configuration Wizard

image

I click Start the Wizard

 

I scroll down and verify that the Visio Graphics Service is Enabled.

image

It appears to be already enabled so I click Cancel.

 

I verify that Microsoft .NET Framework 3.5 SP1 installed so I continue on.

image

 

Ok now I am ready.

 

First I need to install the Visio Services Data Provider.

I log on to my SharePoint server as the Farm Administrator so I have all the permissions I need.

Now I copy the Server folder over to my SharePoint 2010 server in the C:\temp\ directory from the Extensions I downloaded earlier.

image

 

Then I run setup.exe.  Click Next, Next, Close.

 

On my SharePoint server, I open the SharePoint 2010 Management Shell as an Administrator

image

 

In the Command shell I change directories to

C:\Program Files\Visio Services Data Provider for System Center 2012 – Operations Manager

image

 

Now I type in

.\InstallOpsMgrDataModule.ps1

image

 

I click enter and it installs

image

 

I run

get-spsolution

image

I see that it says that is is Deployed so I am good.

 

I also see that another one listed called microsoft.enterprisemanagem…  This is from when I installed the SCOM Dashboard Integration
https://www.scom2k7.com/how-to-view-scom-2012-dashboards-in-sharepoint-2010/  and is not required to make the Visio stuff work.

 

Part 2 – Configuring SharePoint 2010 Integration Components

Ok now I go back to the SharePoint Central Administration Console.  I click Configure service accounts from the Security Section

image

 

From the dropdown I pick Service Application Pool – SharePoint Web Services

image

 

image

 

I need to grant the scom2k7.com\spsvc access to read SCOM.  I double click on the Operations Manager Read-Only Operators and add my SharePoint service account to the Operations Manager Read-Only Operations user role.

 

image

image

 

Ok SharePoint is ready.

Part 3 – Adding your Visio Dashboard to SharePoint 2010

 

I get my SCOM Dashboard Visio document from my previous post.  https://www.scom2k7.com/creating-scom-2012-dashboards-using-visio-2010-or-visio-2013/

 

I open up the diagram document in Visio 2013

image

 

I click Configure to make sure my connection is correct.

image

 

I click File, Save As.  Then I click SharePoint and click Browse.

image

 

I type in the address of my SharePoint Web page in the address bar.

I choose Save as Type: Visio 2010 Web Drawing

Then I click Double Click on Shared Documents.

Now I hit Save.

 

image

 

I get a warning about some Compatibility issue.  I just click Continue.

image

 

I now go to my SharePoint page and click Shared Documents

image

 

I click on my Visio Document and it comes up in a web console.

image

I click Enable (always)

OK now that is done.

Part 4 – Configuring SharePoint 2010 to show your Visio Dashboard as a web part.

 

I want to add my Visio Dashboard as a Web part to my Original SCOM dashboard.

I browse to the actual SharePoint site where I want to display my dashboard.

 

Under Site Actions I click Edit Page

image

 

I Check Out the page

image

 

I put my cursor just below Shared Documents but above my previous dashboard.

image

 

I select Business Data.  Then I select Visio Web Access

 

image

Then I click Add on the middle right of the page.

 

I select Click here to open tool pane.

image

On the right hand side I pick the the … Next to Web Drawing URL

image

 

I then select Shared Documents and select my SCOM-Visio.vdw file.

I changed the Automatic Refresh Interval to 1 minute.

I also de-select Show Open in Visio

image

 

I click OK at the bottom of the screen

Next I click the Format Text tab at the top and Check In the changes and click continue.
image

 

I am finished.  I check out the finished product.

image

Now I just need to create some really cool looking SCOM Visio Dashboards.

10 Responses to Adding SCOM 2012 Visio Dashboards into SharePoint 2010

  1. Harpreet June 4, 2013 at 8:17 am #

    Tim,

    First of all, thanks for sharing this article. I have multiple server farm with multiple WFEs. Do I need to install “Microsoft Visio 2010 and SharePoint 2010 Extensions for System Center 2012” in each WFE and CA. I would appreciate your commnets on it.

  2. salsish September 24, 2013 at 4:41 am #

    “I changed the Automatic Refresh Interval to 1 minute.”

    i did that aswell, and this will update the webpart itself, but not the data from scom. I have 5 minutes between updates from scom, can u tell me where to edit this interval? i dont seem to find it.. oh, btw, nice post bro 😉

  3. Tedmond October 3, 2013 at 5:35 am #

    FYI, I found a little nuance in the OOTB install. The fields for creating a new Visio Graphics Service Application in SharePoint Central Administration do not contain default settings. When creating a new Visio Graphics Service application, specify specific values such as Visio Graphics Service. Otherwise, the install PowerShell script might get a bit boisterous.

  4. dking October 10, 2013 at 7:08 am #

    OK I feel I’m missing something. I don’t have “Service Application Pool – SharePoint web services default”. I only have “Service Application Pool – SharePoint web services system”. I take it I need to rerun some wizard to create these extra application pools?…

  5. James December 31, 2013 at 11:54 am #

    “i did that aswell, and this will update the webpart itself, but not the data from scom. I have 5 minutes between updates from scom, can u tell me where to edit this interval? i dont seem to find it.. oh, btw, nice post bro”

    Great article. I’m also getting ~5 minute refresh interval even when setting webpart to 1 minute. Anyone seen this before?

    thanks

  6. James December 31, 2013 at 12:12 pm #

    figured it out, fo0r anyone else who needs this. Its the “minimum cache age” value. Default is 5 minutes.

    http://technet.microsoft.com/en-us/library/ff805058.aspx

Trackbacks/Pingbacks

  1. SCOM 2012 SP1 – Publish Visio Dashboard in SharePoint 2010 Walkthrough | SCOMfaq.ch - July 10, 2013

    […] had prepared this post some time ago and finally managed to publish it. Well today I found out that Tim McFadden also has done a similar post. Well, if you combine both posts you will definitely manage your Visio […]

  2. Installing SCOM 2012 Visio Dashboards in SharePoint 2013 | Everything System Center Operations Manager by Tim McFadden - September 1, 2014

    […] In a previous post I showed how to install the SCOM 2012 Visio Dashboards on SharePoint 2010. […]

  3. Dashboards in SCOM 2012 | Everything System Center Operations Manager by Tim McFadden - September 1, 2014

    […] Adding SCOM 2012 Visio Dashboards into SharePoint 2010 […]

  4. How To Add A Connection Point In Visio 2010 | Information - February 1, 2017

    […] Adding SCOM 2012 Visio Dashboards into SharePoint 2010 … – Tim, First of all, thanks for sharing this article. I have multiple server farm with multiple WFEs. Do I need to install “Microsoft Visio 2010 and SharePoint 2010 … […]

Leave a Reply