The Deployment Bunny

OS Deployment, Virtualization, Microsoft based Infrastructure…

  • Archives

  • Meta

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.

image

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.

image

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.

How to?

First we need to create a connection to the data source which is done in excel by creating a new data connection using OData

image

The URL is http://srvmdt02:9801/MDTMonitorData/Computers if your server is called SRVMDT02 and you are using the standard port.

image

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.

image

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:

image

Happy Deployment

/mike

4 Responses to “Nice to Know: Connecting Excel 2013 with MDT 2012 Update 1 using OData to get monitor data”

  1. Great post! Thanks

  2. Rob said

    This is great Mikael. Do you know if it is possible to output this odata feed to sharepoint or something?

    Thanks,
    Rob

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: