Flukso Energy Meter Monitoring Pack: Part 4: Seeing it all 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 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 the second part 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 using the Nest Thermostat monitoring pack AND can check on my power consumption and basically control my electrical bill. I’ve created the views in the flukso monitoring view for electricity: Nothing much we can do with this view as this is actually giving me a good reading. It’s in fact what we can do with the data which get into SCOM. Because this data is now into SCOM we can use...
Read More

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

Flukso Energy meter monitoring pack: Part 2: Get data into MySQL

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 installed the device and data is flowing to the flukso website we get a nice graph on our dashboard which is available by logging into the website: Cool… So now we get a clear overview of our energy consumption. But there’s nothing we can do with it basically. We can look at it. Make some adjustments but no alerts, no long term reports nothing… So as I discussed in the first post there’s an open API which makes the data available locally. This is great. No need to retrieve the data from an external website. It stays inside my own network. The setup was very similar to my Nest Thermostat approach because I had that framework already in place I planned to use it the...
Read More

Flukso Energy meter monitoring pack: Part 1: Intro on the device used

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 This post is part of an ongoing series on how to monitor my house with SCOM and build scenarios based on the data that comes into SCOM. More info on the blog series here: http://scug.be/dieter/2014/02/19/monitor-your-home-with-scom/ After monitoring the temperature / humidity and heating in my house I now have turned my focus on the aspects that cost basically money. My electrical bill. To get this data in you need an energy meter. I actually have 2 at the moment so I can level them out to see which one is right… Boys and toys right. They are both of Belgian companies but can be used on any power grid. The above device is called the smappee. It’s a rather new device with a very spacy exterior and lighting. Indeed it’s connecting quite...
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

Monitor your home with SCOM…

So I completely refurbished my house recently…. After getting all the painting done and such it’s now time to focus on the toys which we all love in our home. More and more devices are becoming internet connected these days giving you control and surveillance over your house.  A lot of apps on my phone keep track of different things such as surveillance, heating, power consumption, water consumption, smoke detectors… But they are all different apps… I have a SCOM lab running at home (ok not everybody has a full blown scom lab at home but maybe you can reuse some of my features in your setup). So during one of my scares holidays it got me thinking. Wouldn’t it be cool to have all this data in SCOM. There’s a little added value because all the programs that came with the products are written specifically to deliver the data of that device to your phone but hey I like a challenge. This...
Read More
Monitor your home Notice: Trying to access array offset on value of type bool in /customers/5/1/0/obvus.be/httpd.www/wp-content/themes/square/inc/template-tags.php on line 138