Nice to Know: Connecting Excel 2013 with MDT 2012 Update 1 using OData to get monitor data
Posted by Mikael Nystrom on August 29, 2012
MDT 2012 gives you monitor capabilities and that is very convenient. The basic configuration is that you enable that which will then install a service and then you can use the monitor tab to see and follow the flow of installs. Here is my configuration, I’m using the default ports 9800 and 9801 and the server name is SRVMDT02.
When you enable that a service will be installed (based on .Net of course) and it will also update customsettings.ini to include this setting so that the scripts know where to send data. When all is set up you can see everything in the monitor tab.
But it is possible to consume the data using any method and one easy way which I have started to do is to use Excel 2013. In Excel 2013 it is possible to read OData and that is the format that MDT 2012 is providing. The benefit is that you can create more colorful diagrams, easier to have massive amount of machines, sort, bend, twist and all that.
First we need to create a connection to the data source which is done in excel by creating a new data connection using OData
The URL is
if your server is called SRVMDT02 and you are using the standard port.
Select to connect to the Computers Table Finnish the connection using next-next-until-end principle and in the end select to use a table in the existing Spreadsheet.
Spend 5 minutes to remove the stuff you don’t need and add some fancy coloring and other flashy stuff and it looks like this: