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