Skip Ribbon Commands Skip to main content
 
Tags
 
 
 
 
 
     
Rating: 4.7/5 (3 votes cast)
SharePoint Network Topology Diagram Add-In for Visio 2010

System requirements                   Instructions

Use this add-in to simplify the maintenance and troubleshooting of your Microsoft SharePoint farm infrastructure. This add-in delivers a near real-time, online view of the status of your SharePoint farm, its servers, and their services using Microsoft Visio 2010 and Visio Services in Microsoft SharePoint Server 2010. It has two components:

• SharePoint Topology Data Collection Timer Job. The timer job collects key technical metrics about your SharePoint farm and publishes them as a SharePoint list to a site within the farm
• Visio SharePoint Network Topology Diagram Add-in. This client add-in helps you generate, customize, and link the output of the timer job to a Visio diagram, which may then be puiblished to SharePoint, creating a dynamic dashboard that users can view and refresh.

Additional content:

Download the SharePoint Network Topology sample diagram.

Download contents:

• SMisspelled WordharePointFarmInfoTimerJob.wsp
• sharepointfarminfotimerjobInstall.ps1
• sharepointfarminfotimerjobUninstall.ps1
• SharePoint Topology Data Collection Timer job.msi
• SharePoint Network Topology Diagram Add-In (X86).msi
  or SharePoint Network Topology Diagram Add-In (X64).msi

Publisher: Microsoft

SharePoint Topology Data Collection Timer Job:
• 64-bit edition of Windows Server 2008
• Microsoft Misspelled Word.Net Framework 3.5
• SharePoint 2010
• SharePoint farm administrator permission

SharePoint Network Topology Diagram Add-in:
• Windows operating system (English version or localized English);     Windows 7 preferred
• .NET Framework 3.5
• Visio Professional 2010 or Visio Premium 2010 (Visio Standard 2010 and trial versions not supported)

Note: There are two versions for SharePoint Network Topology Diagram Add-In: one for 32 bit and one for 64 bit environment.

1. Click the download buttons to download the SharePoint Topology Data Collection Timer Job files and the Visio SharePoint Network Topology Diagram Add-in files from the Misspelled WordCodePlex site (both are required). To see all available download files, click the Downloads tab on the Misspelled WordCodePlex site.

2. Follow the instructions in the user guides below to install and configure the timer job and add-in.

Read the user guide for the timer job online.

Expand +

Introduction

SharePoint Topology Data Collection Timer job is intended to collect information related to SharePoint farm, SharePoint Services, SharePoint Server and key metrics such as CPU usage, memory utilization & disk space details. SharePoint Farm administrator can schedule to run this timer job at any desired frequency. For e.g., large farms in a very dynamic environment that need continuous monitoring may require this timer job to be run every half hour or so.
The data resulting from the timer job resides in a SharePoint List. This data can be utilized by SharePoint Network Topology Diagram Add-in – A Visio Add-In that provides an intuitive pictorial representation of the SharePoint farm environment along with its Data Graphics. This diagrammatic representation can then be used as dashboard by SharePoint administrators for various capacity planning and IT maintenance initiatives.

Download Details


Download is available from Misspelled WordMisspelled Wordcodeplex and comprises of the following components: SharePoint Topology Data Collection Timer job Installer
SharePoint Topology Data Collection Timer job WSP
SharePoint Topology Data Collection Timer job Installer Script
SharePoint Topology Data Collection Timer job Uninstaller Script

The MSI installs the WSP file in the farm central administration site. WSP file can also be installed manually or from the PowerShell script. After installation, ensure that WSP file is deployed globally, from the Central Administration -> System Settings -> Manage Farm Solutions

 
 

Ensure that SharePoint Farm Information feature is activated. This can be verified from Central Administration -> Site Settings -> Site Collection features (under Site Collection Administration category)

 

Pre-requisites

This timer job will be installed in the central administration site of the farm server. Farm administrator rights are needed to install and schedule this timer job. Administrators have to configure the Timer job settings and schedule it.
 
 

After providing the timer job input details and scheduling it. It is advised to restart the SharePoint 2010 timer service as shown below. This PowerShell script restarts the SharePoint 2010 timer service when executed with admin privileges.

 
 

SharePoint Topology Data Collection Timer Job Settings

This page is found in the monitoring.aspx of the central administration site. Click on SharePoint Topology Data Collection Timer Job Settings under the Timer job.
 
 
 
 

The resulting page as shown below seeks all the necessary input from the user in order to configure the SharePoint List that is to be created with necessary.
 

Scheduling Timer Job

Click on Central Administration -> Monitoring -> Review Job Definitions -> SharePoint Topology Data Collection Timer Job.
 

Based on the network and other relevant parameters related to the specific infrastructure, users should schedule the timer job and click ok. Note that SharePoint 2010 Timer – A Windows service has to be restarted after this configuration.

SharePoint List

A SharePoint List with the name specified in the configuration is created.
 

This SharePoint List contains the following list of columns. Also, column name descriptions are provided below.



 
 
 

Custom Views for SharePoint List

This SharePoint List comprises of 3 custom views for better filtering and readability. The data is grouped based on the Server name. At any time it can be changed according to the requirement and needs
 
All Items: All columns are shown.

SharePoint Farm List View: This List View gives information about the SharePoint Farm details. It gives information about the SharePoint Farm configuration database and its Size.
 
 

SharePoint Farm Server List View: This view provides information about each and every server in the SharePoint farm. In addition, it provides information about the CPU, memory and disk space details.

 

SharePoint Farm Service List View: This view is provides information about the SharePoint services across the SharePoint servers and respective statuses.

 
 

Read the user guide for the add-in online.

Expand +

Introduction

SharePoint Network Topology Diagram Add-in leverages Visio services to deliver a near real time intuitive rendering of the status of SharePoint farm infrastructure and associated services. Visio Graphics services – A key part of SharePoint 2010, enable customers to share their dynamic data driven Visio diagrams and dashboards within SharePoint. This helps extend the reach of valuable information and insights across relevant teams within the enterprise for capacity planning and IT maintenance.

The timer job fetches all the key technical metrics about the SharePoint farm infrastructure using SharePoint object model and WMI (Windows Management Instrumentation). It’s frequency can be adjusted based on specific administrative needs. The timer job creates a SharePoint list that is linked to a Visio diagram. The client add-in helps you generate, customize and link the output of the timer job to a Visio diagram by using a wizard driven interface.

Upon publishing the Visio diagram within SharePoint, Visio services enable users to refresh their diagram from within SharePoint.


Pre-requisites

• English version or Localized English version of Windows OS. Windows 7 is preferred.
Misspelled WordMisspelled Word.Net Framework 3.5
• Visio 2010 Licensed Professional or Premium version. Visio 2010 standard version and trial versions are not supported.

Note: Two versions, one for 32 bit and one for 64 bit are available. Please choose the appropriate version according to your environment.


Launching the SharePoint Network Topology Add-In

Open Visio and navigate to Select File -> New -> Add-Ins. Select SharePoint Network Topology Template and click on Create button below the template on the right side. Double clicking SharePoint Network Topology Template will also launch a new document.

 

Notice a new tab as shown below. The rest of this document will walk you through every controls in this tab.




Linking data to SharePoint

Before launching or clicking this control, ensure that the SharePoint farm information has been created by the SharePoint Topology Data Collection Timer Job and is published out as SharePoint list. This serves as the key input for this step.

Click on Link data to SharePoint button to launch the SharePoint Network Topology Data selector wizard.

Click on Next button to input the SharePoint details. Now Input the SharePoint Site name and the SharePoint List name which are created by the Timer Job. Error messages will be displayed if incorrect values are fed. Please refer to the trouble shooting section for the list of validation messages.

 
 

Note: Depending on network and system performance, it might take a while to establish connection with the SharePoint site and validate the SharePoint List schema.

Click Next to select the list of columns. Server Name, Service Name and Object Type are mandatory columns. These columns are pre-selected by default and can’t be unselected. Please select the rest of KPI’s. Select All is preferred since all the KPIs are used by the data graphics in the diagram generation. Un-selection some may result in blank data graphics.

 
 

Click Next to proceed to the summary screen. This shows the summary of all the details collected by the wizard. Click Finish to end the wizard.

 
 

After successfully accomplishing all these steps, a data connection to the SharePoint List is created with the selected columns.

 
 

Linking Data to shapes / objects

On the add-on ribbon, click on Link Data to Shapes button.

 
 

The external data can be obtained from a wide variety of sources as shown below.

 

The three mandatory column names can also be mapped to more Misspelled WordMisspelled Wordrespresentative names too. To do so, open the install location. Locate the Misspelled WordMisspelled WordSPNetworkTopology.dll.config file and edit it notepad.

 
 

Input a more meaningful representative name as the value for the key parameters.


Configure

This option configures the list of SharePoint services that have to be displayed during the diagram generation step. Click on the configure button to launch the SharePoint Service Selection wizard.

 

By default all the services are selected. Select the specific SharePoint services that need to be displayed. At least one service has to be selected. 


Generate Diagram

Click on the Generate Diagram to generate the diagram. This auto generates SharePoint Network diagram and SharePoint Service diagrams across multiple tabs.

 

The diagram has built-in Data Graphics to intuitively display the diagram. For SharePoint servers: CPU Usage, Memory Usage and Free Space percent are displayed with relevant Data Graphics.

 

For SharePoint Farm: Specific version of the SharePoint, Configuration DB name and its size are shown with relevant Data Graphics.

 

For every SharePoint server a new page is created with name <<Misspelled WordMisspelled WordSharePointServer name>> – Service Details. It shows the list of configured services. By default all the 39 services are listed. Green shows that the service is up and running while red denotes that the service is disabled.

 

Needs upgrade and Can upgrade KPIs are also shown in the Data Graphics for all the objects.

The Data Graphics can be changed at any time and can be published to SharePoint. In SharePoint, Visio Graphics Services refreshes the diagram to display the latest information.

Note: The diagram can be adjusted or created manually from the custom stencil file and can be linked to the data from the external data window. 


Enhancing the Design

Upon initial diagram generation, further enhancements are possible. Legends can be inserted. To insert Legend, follow Data -> Insert Legend. By default Legend will be dropped to the right corner of the page.
The placement of the legend can be adjusted.

 

To use one of the design Misspelled WordMisspelled Wordtemplatse, click on Design Tab and mouse over the available themes. Select the theme that matches your need.



The Layout of the diagram can be changed by selecting the layout option in the design tab.

 
 

The About Option provides information about the Add-In such as the version number along with the support information.

 
 

Troubleshooting

Following are the list of error messages shown while linking data to SharePoint List. SharePoint Site Name and SharePoint List Name are mandatory fields. They should be provided with value.

The following error message is displayed when the SharePoint Site Name is empty. 




The following error message is displayed when the SharePoint List name is empty.



Following error message is displayed when the SharePoint List does not exist.



Following error message is displayed when the SharePoint list exists but schema validation failed.