{"id":660,"date":"2021-01-31T20:27:20","date_gmt":"2021-01-31T19:27:20","guid":{"rendered":"http:\/\/thomas-kopton.de\/vblog\/?p=660"},"modified":"2021-01-31T20:27:20","modified_gmt":"2021-01-31T19:27:20","slug":"energy-consumption-monitoring-using-sml-data-and-vrealize-log-insight","status":"publish","type":"post","link":"https:\/\/thomas-kopton.de\/vblog\/?p=660","title":{"rendered":"Energy Consumption Monitoring using SML Data and vRealize Log Insight"},"content":{"rendered":"\n<p>It all started with my last electricity bill. Shortly after I have recovered from the shock and made sure that I really do not have any aluminum\u00a0smelter running in my basement, I decided, I need some kind of monitoring of my electric energy consumption.<\/p>\n\n\n\n<p>Insights into data is the first and probably most important step in the process of taking measures to change any given situation.<\/p>\n\n\n\n<p>My plan was to consume the available <strong><span style=\"color:#2288c3\" class=\"has-inline-color\">Smart Messaging Language<\/span><\/strong> (SML) data and following that post (sorry, it is in German only) create a real-time dashboard:<\/p>\n\n\n\n<p><a href=\"http:\/\/raspberry.tips\/raspberrypi-tutorials\/smartmeter-stromzaehler-mit-dem-raspberry-pi-auslesen-und-aufzeichnen\">http:\/\/raspberry.tips\/raspberrypi-tutorials\/smartmeter-stromzaehler-mit-dem-raspberry-pi-auslesen-und-aufzeichnen<\/a><\/p>\n\n\n\n<p>No sooner said than done and only after few steps I have realized that it will be slightly more work to let the included webserver run on the same Raspberry PI which is already running my PI-hole??.<\/p>\n\n\n\n<p>OK, invest time to change the scripts and build the dashboard into the PI-hole web server or use another Raspberry and start over?<\/p>\n\n\n\n<p>As I already have the data available in the vzlogger.log file why shouldn&#8217;t I use my <strong>vRealize Loginsight<\/strong> to display it? Sure, semantically I am dealing with time-series data here and another vRealize product would be more suitable but I wanted something quick and easy &#8211; no worries, vRealize Operations and\/or Wavefront integration is already on my to-do list.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">The Data<\/h4>\n\n\n\n<p>vzlogger <a href=\"https:\/\/github.com\/volkszaehler\/vzlogger\">(https:\/\/github.com\/volkszaehler\/vzlogger<\/a>) reads the SML telegrams coming from the smart meter via serial port and stores the readings every two seconds in a log file. I have configured the log file to be: <code>\/var\/log\/vzlogger\/vzlogger.log <\/code><\/p>\n\n\n\n<p><code>[Jan 30 19:21:46][mtr0] Got 5 new readings from meter:<br>[Jan 30 19:21:46][mtr0] Reading: id=1-0:1.8.0<em>255\/ObisIdentifier:1-0:1.8.0<\/em>255 value=38768802.85 ts=1612030906436<br>[Jan 30 19:21:46][mtr0] Reading: id=1-0:1.8.1<em>255\/ObisIdentifier:1-0:1.8.1<\/em>255 value=15102120.00 ts=1612030906436<br>[Jan 30 19:21:46][mtr0] Reading: id=1-0:1.8.2<em>255\/ObisIdentifier:1-0:1.8.2<\/em>255 value=23666680.00 ts=1612030906436<br>[Jan 30 19:21:46][mtr0] Reading: id=1-0:1.7.0<em>255\/ObisIdentifier:1-0:1.7.0<\/em>255 value=386.51 ts=1612030906436<br>[Jan 30 19:21:46][mtr0] Reading: id=1-0:96.5.5<em>255\/ObisIdentifier:1-0:96.5.5<\/em>255 value=6560.00 ts=1612030906436<\/code><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Syslog Configuration<\/h4>\n\n\n\n<p>As I do not have a vRLI Agent for the ARM platform I decided to use <code>rsyslog<\/code> to send the log file entries to vRealize Log Insight.<\/p>\n\n\n\n<p>The configuration follows the <code>rsyslog<\/code> procedures. I have simply created an appropriate file in <code>\/etc\/rsyslog.d<\/code><\/p>\n\n\n\n<p><code><span class=\"has-inline-color has-vivid-cyan-blue-color\">vzlogger.conf<\/span><\/code><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ModLoad imfile\n$InputFileName \/var\/log\/vzlogger\/vzlogger.log\n$InputFileTag vzlogger\n# $InputFileStateFile\n$InputFilePollInterval 10\n$InputFileSeverity info\n$InputFileFacility local3\n$InputRunFileMonitor\nlocal3.* @@xxx.xxx.xxx.xxx<\/code><\/pre>\n\n\n\n<p><code>xxx.xxx.xxx.xxx<\/code> in <code>@@xxx.xxx.xxx.xxx<\/code> is of course the IP of my vRealize Log Insight instance.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">vRealize Log Insight Configuration<\/h4>\n\n\n\n<p>After restarting the <code>rsyslog<\/code> daemon the SML decoded messages start arriving in vRLI every 10 seconds as configured in <code>vzlogger.conf<\/code>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><a href=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-01.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-01-1024x577.png\" alt=\"\" class=\"wp-image-674\" width=\"768\" height=\"433\" srcset=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-01-1024x577.png 1024w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-01-300x169.png 300w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-01-768x433.png 768w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-01-1536x866.png 1536w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-01-2048x1154.png 2048w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/a><figcaption><em>Figure 01: vzlogger messages in vRealize Log Insight<\/em><\/figcaption><\/figure>\n\n\n\n<p>vRealize Log Insight <strong>Extracted Fields<\/strong> are a good way to extract the actual metrics defined by the <strong><span style=\"color:#1891c5\" class=\"has-inline-color\">Object Identification System<\/span><\/strong> (OBIS):<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>ObisIdentifier:1-0:<strong>1.7.0<\/strong>\u00a0= key 1.7.0 = Current consuption in (WATT)<\/li><li>ObisIdentifier:1-0:<strong>1.8.1<\/strong>\u00a0= key 1.8.1 = Accumulated consumption &#8211; rate 1 (meter reading)<\/li><li>ObisIdentifier:1-0:<strong>1.8.2<\/strong>\u00a0= key 1.8.2 = Accumulated consumption &#8211; rate 2 (meter reading)<\/li><\/ul>\n\n\n\n<p>To make the extraction of the value efficient, I am using the hostname of the data source as <strong>additional context<\/strong>. Additional context ensures that vRLI does not have to parse every single log message arriving in vRLI. Only messages coming from my Raspberry PI will be parsed.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-02.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"228\" src=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-02-1024x228.png\" alt=\"\" class=\"wp-image-676\" srcset=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-02-1024x228.png 1024w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-02-300x67.png 300w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-02-768x171.png 768w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-02-1536x342.png 1536w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-02-2048x456.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption><em>Figure 02: Extracted Field used to assign the actual metric, consumption, to a searchable field<\/em><\/figcaption><\/figure>\n\n\n\n<p>Additionally I extract the OBIS key to use both, key and value to create my <strong>dashboards<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-03.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"283\" src=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-03-1024x283.png\" alt=\"\" class=\"wp-image-680\" srcset=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-03-1024x283.png 1024w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-03-300x83.png 300w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-03-768x212.png 768w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-03-1536x424.png 1536w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-03-2048x565.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption><em>Figure 03: OBIS key as Extracted Field<\/em><\/figcaption><\/figure>\n\n\n\n<p>Now it is easy to show the actual consumption using both extracted fields.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><a href=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-04.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-04-1024x542.png\" alt=\"\" class=\"wp-image-681\" width=\"580\" height=\"306\" srcset=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-04-1024x542.png 1024w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-04-300x159.png 300w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-04-768x407.png 768w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-04-1536x813.png 1536w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-04-2048x1084.png 2048w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><figcaption><em>Figure 04: Current consumption as max and average<\/em><\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">vRealize Log Insight Dashboard (Sharing)<\/h4>\n\n\n\n<p>Information made visible in the vRealize Log Insight Interactive Analytics can be added to a dashboard and <strong>shared<\/strong> with other users.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-04.2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"418\" src=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-04.2-1024x418.png\" alt=\"\" class=\"wp-image-684\" srcset=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-04.2-1024x418.png 1024w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-04.2-300x123.png 300w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-04.2-768x314.png 768w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-04.2-1536x628.png 1536w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-04.2-2048x837.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption><em>Figure 05: Creating a shared dashboard<\/em><\/figcaption><\/figure>\n\n\n\n<p>The dashboard can have <strong>multiple<\/strong> <strong>widgets<\/strong> and give you a quick insight into the collected data. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-05-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"484\" src=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-05-1-1024x484.png\" alt=\"\" class=\"wp-image-686\" srcset=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-05-1-1024x484.png 1024w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-05-1-300x142.png 300w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-05-1-768x363.png 768w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-05-1-1536x726.png 1536w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-05-1-2048x968.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption><em>Figure 06: Electric energy consumption dashboard<\/em><\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">vRealize Log Insight Partition<\/h4>\n\n\n\n<p>Another fairly new (since 8.1) feature of vRealize Log Insight I have used in this example is <strong>Data Partitions<\/strong>.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>You can retain log data in a partition with a filter and a retention period. Data partitions let you define different retention periods for different types of logs. For example, logs with sensitive information might require a short retention period, such as five days. The log data that matches the filter criteria for a data partition is stored in the partition for the specified retention period. Logs that do not match the filter criteria in any of the defined data partitions are stored in the default partition. This partition is always enabled and stores data for an unlimited amount of time. You can modify the retention period for the default partition.<\/p><\/blockquote>\n\n\n\n<p>I have created a partition for the energy data to retain that data for 90 days. My host bajor is sending only the vzlogger messages so I can use the hostname as <strong>filter<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-06.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"360\" src=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-06-1024x360.png\" alt=\"\" class=\"wp-image-690\" srcset=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-06-1024x360.png 1024w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-06-300x106.png 300w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-06-768x270.png 768w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-06-1536x541.png 1536w, https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-06.png 1960w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption><em>Figure 07: Data partition for the energy consumption data<\/em><\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Outlook<\/h4>\n\n\n\n<p>As the next project, I am planning to send the metrics to vRealize Operations or Wavefront to treat them as time-series data and allow for more sophisticated analytics.<\/p>\n\n\n\n<p><strong>Stay safe.<\/strong><\/p>\n\n\n\n<p>Thomas \u2013&nbsp;<a href=\"https:\/\/twitter.com\/ThomasKopton\">https:\/\/twitter.com\/ThomasKopton<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>It all started with my last electricity bill. Shortly after I have recovered from the shock and made sure that I really do not have any aluminum\u00a0smelter running in my basement, I decided, I need some kind of monitoring of my electric energy consumption. Insights into data is the first and probably most important step &#8230;<\/p>\n","protected":false},"author":1,"featured_media":686,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,5],"tags":[25,7],"class_list":["post-660","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-vrealize-log-insight","category-vrli","tag-vrealize-log-insight","tag-vrli"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Energy Consumption Monitoring using SML Data and vRealize Log Insight - TOMsOps<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/thomas-kopton.de\/vblog\/?p=660\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Energy Consumption Monitoring using SML Data and vRealize Log Insight - TOMsOps\" \/>\n<meta property=\"og:description\" content=\"It all started with my last electricity bill. Shortly after I have recovered from the shock and made sure that I really do not have any aluminum\u00a0smelter running in my basement, I decided, I need some kind of monitoring of my electric energy consumption. Insights into data is the first and probably most important step ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/thomas-kopton.de\/vblog\/?p=660\" \/>\n<meta property=\"og:site_name\" content=\"TOMsOps\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-31T19:27:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-05-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2780\" \/>\n\t<meta property=\"og:image:height\" content=\"1314\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Thomas Kopton\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Thomas Kopton\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/thomas-kopton.de\/vblog\/?p=660#article\",\"isPartOf\":{\"@id\":\"https:\/\/thomas-kopton.de\/vblog\/?p=660\"},\"author\":{\"name\":\"Thomas Kopton\",\"@id\":\"https:\/\/thomas-kopton.de\/vblog\/#\/schema\/person\/892d6b96c66b1dd4b75c6e32fdbfea82\"},\"headline\":\"Energy Consumption Monitoring using SML Data and vRealize Log Insight\",\"datePublished\":\"2021-01-31T19:27:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/thomas-kopton.de\/vblog\/?p=660\"},\"wordCount\":761,\"commentCount\":1,\"image\":{\"@id\":\"https:\/\/thomas-kopton.de\/vblog\/?p=660#primaryimage\"},\"thumbnailUrl\":\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-05-1.png\",\"keywords\":[\"vRealize log insight\",\"vRLI\"],\"articleSection\":[\"vRealize Log Insight\",\"vRLI\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/thomas-kopton.de\/vblog\/?p=660#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/thomas-kopton.de\/vblog\/?p=660\",\"url\":\"https:\/\/thomas-kopton.de\/vblog\/?p=660\",\"name\":\"Energy Consumption Monitoring using SML Data and vRealize Log Insight - TOMsOps\",\"isPartOf\":{\"@id\":\"https:\/\/thomas-kopton.de\/vblog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/thomas-kopton.de\/vblog\/?p=660#primaryimage\"},\"image\":{\"@id\":\"https:\/\/thomas-kopton.de\/vblog\/?p=660#primaryimage\"},\"thumbnailUrl\":\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-05-1.png\",\"datePublished\":\"2021-01-31T19:27:20+00:00\",\"author\":{\"@id\":\"https:\/\/thomas-kopton.de\/vblog\/#\/schema\/person\/892d6b96c66b1dd4b75c6e32fdbfea82\"},\"breadcrumb\":{\"@id\":\"https:\/\/thomas-kopton.de\/vblog\/?p=660#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/thomas-kopton.de\/vblog\/?p=660\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/thomas-kopton.de\/vblog\/?p=660#primaryimage\",\"url\":\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-05-1.png\",\"contentUrl\":\"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-05-1.png\",\"width\":2780,\"height\":1314},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/thomas-kopton.de\/vblog\/?p=660#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/thomas-kopton.de\/vblog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Energy Consumption Monitoring using SML Data and vRealize Log Insight\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/thomas-kopton.de\/vblog\/#website\",\"url\":\"https:\/\/thomas-kopton.de\/vblog\/\",\"name\":\"TOMsOps\",\"description\":\"Just another VMware Cloud Management Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/thomas-kopton.de\/vblog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/thomas-kopton.de\/vblog\/#\/schema\/person\/892d6b96c66b1dd4b75c6e32fdbfea82\",\"name\":\"Thomas Kopton\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/thomas-kopton.de\/vblog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e746aafbd3733172ceb4d600ba1feda61bc87cd3b70f5a9dfb581907cc7973b1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e746aafbd3733172ceb4d600ba1feda61bc87cd3b70f5a9dfb581907cc7973b1?s=96&d=mm&r=g\",\"caption\":\"Thomas Kopton\"},\"url\":\"https:\/\/thomas-kopton.de\/vblog\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Energy Consumption Monitoring using SML Data and vRealize Log Insight - TOMsOps","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/thomas-kopton.de\/vblog\/?p=660","og_locale":"en_US","og_type":"article","og_title":"Energy Consumption Monitoring using SML Data and vRealize Log Insight - TOMsOps","og_description":"It all started with my last electricity bill. Shortly after I have recovered from the shock and made sure that I really do not have any aluminum\u00a0smelter running in my basement, I decided, I need some kind of monitoring of my electric energy consumption. Insights into data is the first and probably most important step ...","og_url":"https:\/\/thomas-kopton.de\/vblog\/?p=660","og_site_name":"TOMsOps","article_published_time":"2021-01-31T19:27:20+00:00","og_image":[{"width":2780,"height":1314,"url":"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-05-1.png","type":"image\/png"}],"author":"Thomas Kopton","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Thomas Kopton","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/thomas-kopton.de\/vblog\/?p=660#article","isPartOf":{"@id":"https:\/\/thomas-kopton.de\/vblog\/?p=660"},"author":{"name":"Thomas Kopton","@id":"https:\/\/thomas-kopton.de\/vblog\/#\/schema\/person\/892d6b96c66b1dd4b75c6e32fdbfea82"},"headline":"Energy Consumption Monitoring using SML Data and vRealize Log Insight","datePublished":"2021-01-31T19:27:20+00:00","mainEntityOfPage":{"@id":"https:\/\/thomas-kopton.de\/vblog\/?p=660"},"wordCount":761,"commentCount":1,"image":{"@id":"https:\/\/thomas-kopton.de\/vblog\/?p=660#primaryimage"},"thumbnailUrl":"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-05-1.png","keywords":["vRealize log insight","vRLI"],"articleSection":["vRealize Log Insight","vRLI"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/thomas-kopton.de\/vblog\/?p=660#respond"]}]},{"@type":"WebPage","@id":"https:\/\/thomas-kopton.de\/vblog\/?p=660","url":"https:\/\/thomas-kopton.de\/vblog\/?p=660","name":"Energy Consumption Monitoring using SML Data and vRealize Log Insight - TOMsOps","isPartOf":{"@id":"https:\/\/thomas-kopton.de\/vblog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/thomas-kopton.de\/vblog\/?p=660#primaryimage"},"image":{"@id":"https:\/\/thomas-kopton.de\/vblog\/?p=660#primaryimage"},"thumbnailUrl":"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-05-1.png","datePublished":"2021-01-31T19:27:20+00:00","author":{"@id":"https:\/\/thomas-kopton.de\/vblog\/#\/schema\/person\/892d6b96c66b1dd4b75c6e32fdbfea82"},"breadcrumb":{"@id":"https:\/\/thomas-kopton.de\/vblog\/?p=660#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/thomas-kopton.de\/vblog\/?p=660"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/thomas-kopton.de\/vblog\/?p=660#primaryimage","url":"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-05-1.png","contentUrl":"https:\/\/thomas-kopton.de\/vblog\/wp-content\/uploads\/2021\/01\/figure-05-1.png","width":2780,"height":1314},{"@type":"BreadcrumbList","@id":"https:\/\/thomas-kopton.de\/vblog\/?p=660#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/thomas-kopton.de\/vblog"},{"@type":"ListItem","position":2,"name":"Energy Consumption Monitoring using SML Data and vRealize Log Insight"}]},{"@type":"WebSite","@id":"https:\/\/thomas-kopton.de\/vblog\/#website","url":"https:\/\/thomas-kopton.de\/vblog\/","name":"TOMsOps","description":"Just another VMware Cloud Management Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/thomas-kopton.de\/vblog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/thomas-kopton.de\/vblog\/#\/schema\/person\/892d6b96c66b1dd4b75c6e32fdbfea82","name":"Thomas Kopton","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/thomas-kopton.de\/vblog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e746aafbd3733172ceb4d600ba1feda61bc87cd3b70f5a9dfb581907cc7973b1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e746aafbd3733172ceb4d600ba1feda61bc87cd3b70f5a9dfb581907cc7973b1?s=96&d=mm&r=g","caption":"Thomas Kopton"},"url":"https:\/\/thomas-kopton.de\/vblog\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/thomas-kopton.de\/vblog\/index.php?rest_route=\/wp\/v2\/posts\/660","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thomas-kopton.de\/vblog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thomas-kopton.de\/vblog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thomas-kopton.de\/vblog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thomas-kopton.de\/vblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=660"}],"version-history":[{"count":25,"href":"https:\/\/thomas-kopton.de\/vblog\/index.php?rest_route=\/wp\/v2\/posts\/660\/revisions"}],"predecessor-version":[{"id":693,"href":"https:\/\/thomas-kopton.de\/vblog\/index.php?rest_route=\/wp\/v2\/posts\/660\/revisions\/693"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thomas-kopton.de\/vblog\/index.php?rest_route=\/wp\/v2\/media\/686"}],"wp:attachment":[{"href":"https:\/\/thomas-kopton.de\/vblog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=660"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thomas-kopton.de\/vblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=660"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thomas-kopton.de\/vblog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=660"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}