Flukso Energy meter monitoring pack: Part 3: Get data into SCOM

This blog post is part of a series check out the other posts in this series: Part 1: Intro on the device used Part 2: Get data into MySQL Part 3: Get data into SCOM Part 4: Seeing it in action So after we have successfully set up the connection between the flukso and our mysql dbase with basically following the same route as the nest thermostat data is pouring into our own dbase on the same device.. The only thing left to do is get this data in SCOM as well. I’ve created a separate management pack and PowerShell script for this to give people the ability to install it separate from each other but the goal is to create one big management pack in the end. This blog post will explain how to retrieve the data with PowerShell (of course) and dump it into a property bag which is readable by SCOM. This is the second phase in our schematic example: Requirements We basically need the same requirements as for...
Read More

Nest Thermostat monitoring pack: Part 4 seeing it in action

This blog post is part of a series check out the other posts in this series: Part 1: How did I get data Part 2: Get data into SCOM from MySQL Part 3: Create the MP Part 4: Seeing it in action Part 5: Limit the max temperature So after all this hard work. To get the data into my MySQL dbase and into SCOM. What can I actually do with it? This is just the beginning of a far greater monitoring project I’m building to basically monitor my house but now I have control over the temperature and heating in my house. I’ve created the views in the nest folder for humidity, Heating status and a separate view for target and current temperature. Humidity view: Nothing much we can do with this view as this is actually giving me a good reading. Everything between 30 and 60 is healthy condition so no complaints here. Next in line is the Heating status: This is basically a Boolean (on or off). The standard...
Read More

Nest Thermostat monitoring pack: Part 3: Create the mp

This blog post is part of a series check out the other posts in this series: Part 1: How did I get data Part 2: Get data into SCOM from MySQL Part 3: Create the MP Part 4: Seeing it in action Part 5: Limit the max temperature The Nest thermostat monitoring pack is in general part of a “monitor your home with scom” series which can be found here: http://scug.be/dieter/2014/02/19/monitor-your-home-with-scom/ Download the MP I've created here: http://scug.be/dieter/?p=1204 Now that we have discussed how to get the data from the Nest website via an api call into our dbase where we were able to get the data via PowerShell into a property bag. It’s now time to get SCOM working with this data. I’m gathering a sample of the dbase every 5 minutes and the dbase itself is filled with data only when there was a call home from the device to the Nest website. As some of you will probably already know it’s not possible to use a PowerShell script...
Read More

Nest Thermostat monitoring pack: Part 2: Get data into SCOM from MySQL

This blog post is part of a series check out the other posts in this series:Part 1: How did I get dataPart 2: Get data into SCOM from MySQLPart 3: Create the MPPart 4: Seeing it in actionPart 5: Limit the max temperatureSo after we have successfully set up the connection between the nest and our mysql dbase data is pouring into our own dbase. So how do we get that data into SCOM so we can graph it and monitor it.This blogpost will explain how to retrieve the data with PowerShell (of course) and dump it into a property bag which is readable by SCOM. This is the second phase in our schematic example:RequirementsWhat do we need to retrieve the data out of the MySQL dbase.A watchernode which has PowerShell V2.0 installed (can be a server or a desktop laying somewhere)a reg key to identify this watcher node. I’m using “HKLM\SOFTWARE\NEST\Watchernode” for thisThe mysql connector installed: http://dev.mysql.com/downloads/connector/net/ (note in...
Read More

Nest Thermostat monitoring pack: Part I: How did I get data?

This blog post is part of a series check out the other posts in this series: Part 1: How did I get data Part 2: Get data into SCOM from MySQL Part 3: Create the MP Part 4: Seeing it in action Part 5: Limit the max temperature I recently bought myself a Nest Thermostat. For those who are not familiar with this device. It’s basically an internet connected thermostat which learns your heating patterns with different variables. It’s of course packaged in a nice futuristic design… Cool… More info here: https://nest.com/thermostat/life-with-nest-thermostat/ Although it is not officially released in Europe nor supported it’s actually quite easy to install. If you are reading this and need more info please make sure to check out this blog post: http://www.fousa.be/blog/nest-thermostat So I survived the installation… This round eye thing as my wife refers to it is doing its job nicely. I get a lot of feedback from the app and even on the website. Everything looks shiny and cool… But… What if… What...
Read More