The Data Linking and Data Graphic features in Visio 2010 give you the ability to create very interesting and artistic dashboards, but the trick is to get the data that you need into a data source that Visio and Visio Services can refresh from. For this article I wanted to highlight a method that some customers are using, gathering data from WMI and pushing it to a SharePoint list, from which Visio Services can easily refresh from.
At the end of this article is a ZIP containing my PowerShell script that gathers the data using WMI and pushes it to a configured SharePoint list, a BAT file that I use as the means to execute the PowerShell script via a Task from Windows Task Scheduler, and my sample diagram so you can see how I configured my shapes and my Data Graphics.
Hello this looks really interesting, what is the load on the server? also is there a limit to how many servers can report to the Sharepoint List? We have about 15K servers.
I'm getting this error below:
new-object : Cannot find type [Microsoft.SharePoint.SPSite]: make sure the
assembly containing this type is loaded.
What else do i need to do?