October 7, 2011 3 Comments
The tool is designed to automatically collect topology data about from your SharePoint farm and to automate the creation of Visio diagrams that illustrate this topology via data connected diagrams – very cool!
Timer Job Installation
Install the SharePoint Topology Data Collection Tool. Note: This tool required the .Net Framework v4 to be present on the farm:
Once this tool has installed, check Central Admin for the following items. Under Monitoring > Timer Jobs you should see a new option appear on the monitoring home page called ‘SharePoint Topology Data Job Settings’:
Additionally, under Monitoring > Review job definitions, you should see a new timer job entitled ‘SharePoint Topology Data Collection Timer Job’:
Before we run the SharePoint Topology Data Collection Timer Job, we need to configure the timer job settings, so back to Monitoring > Timer Jobs > SharePoint Topology Data Job Settings. From here, enter a valid
From here, pick a Web Application, Site Collection, Site, and List name to store the collected topology data. You don’t have to use central admin like I have done but you might want to so that access to the topology data is restricted. Additionally, note that the list name entered does not have to already exist, the timer job will create the list the next time it runs.
From Monitoring > Review job definitions, run the SharePoint Topology Data Collection Time Job. Once this job has run, you should notice a new list appeared in the location you specified in Step 3 and it will be populated with a number of different rows that the timer jobs has created:
In my single server development farm the timer job created 45 rows.
If you see this list and it contains data, then the installation and configuration of the timer job is complete and you can move onto the Visio add-in installation
Visio Installation and Data Connection
Now that the timer job is installed and working, we can configure the Visio add-in. Install the Visio SharePoint Network Topology Add-in and note the installation directory. Once the installation is complete, navigate to the installation directory and locate the SPNetworkTopology.vsto file:
Open this file and the Microsoft Office Customization Installer will prompt you to accept the package. Continue by accepting the package.
Once the package is installed, start up Visio and check the add-in is installed, File > Options > Add-ins:
Create a new Visio diagram from the SharePoint Network Topology template the add-in has enabled. If this template is not immediately available to you, you should find it under the Add-Ins folder under the File > New options:
When you open a diagram that has been created from the SharePoint Network Topology template, a new ribbon will appear called SharePoint Topology:
We will use this ribbon to create our diagram based on the data collected via the timer job. From the SharePoint Topology ribbon, select the Link Data to SharePoint action, to access the SharePoint Network Topology Data Selector:
Click Next, and then enter the SharePoint site url and link name we configured in the timer job settings:
On the Column Selection screen, choose the properties (columns) you would like available in your diagram (I’ve chosen ‘Select All’):
Finally, confirm your selections and click Finish:
Now that we have completed the Link Data to SharePoint action, our Visio diagram should have a data connection to the SharePoint list that contains our topology data. Now it is time to use this data.
Navigate to the first page that is created for us, ‘SharePoint Network Topology’:
From the ribbon, select Generate Diagram:
Now the magic begins! The add-in will use the topology data collected to automatically generate a diagram of your SharePoint Topology that is data bound to the topology data collected from the timer job. This means that once the diagram has been created you can refresh it at any time to review changes in your topology and its performance – very nice!
Navigate to the Service Details page and repeat Step 2.
The diagrams that were created in steps 2 & 3 for my single server farm are shown below. Obviously in a larger farm these diagrams will contain more servers and more details:
I’ll publish some more complex diagrams once I’ve run the tool in my test lab.
Now the diagrams are available you can review the diagrams and decorate them with further data visualisations. See Display a data-connected Visio drawing in a SharePoint web part for more details on how to do this and how you can publish this dynamic diagram to SharePoint.