{"id":571,"date":"2018-08-25T01:04:55","date_gmt":"2018-08-25T01:04:55","guid":{"rendered":"http:\/\/www.ciraltos.com\/?p=571"},"modified":"2018-08-25T01:04:55","modified_gmt":"2018-08-25T01:04:55","slug":"log-ping-response-to-log-analytics","status":"publish","type":"post","link":"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/","title":{"rendered":"Log Ping Response to Log Analytics"},"content":{"rendered":"

\"\"Today I am publishing a utility called PingTimeLog.\u00a0 The idea is simple; ping a group of servers and write the response time to Azure Log Analytics. This utility is intended to be run as a Runbook on an Azure Automation Hybrid Worker. \u00a0Alternatively, it will run as a scheduled task on a server in your datacenter.\u00a0 <\/span>The output is written to Azure Log Analytics as a custom Type, allowing users to plot response times in a time chart.<\/span><\/p>\n

<\/p>\n

But First, Why?<\/span><\/h2>\n

The goal is to view WAN latency between a central data center and remote sites to track SLA and alert if latency falls outside a given range. \u00a0The draft version wrote data to Azure Table Storage with the intent to use PowerBI to report on the response rate.\u00a0 <\/span>Turns out, it far easier to log the data to Log Analytics with the Log Analytics HTTP Data Collector API. \u00a0<\/span><\/p>\n

I feel compelled to point out that there are a lot of other tools available with more features for monitoring latency on a WAN circuit. \u00a0PingPlotter is one that comes to mind as a tool that can track more than just response time.\u00a0 <\/span>One of the goals, however, was write the data to Log Analytics. Logging to Log Analytics allows me to leverage one dashboard to monitor WAN latency along with other infrastructure health indicators.\u00a0 An example of a Ling Chart below\u00a0 That was not an easy option with third party tools.\u00a0 <\/span>The other factor was price.\u00a0 <\/span>Most 3rd party tools cost money, but PowerShell, and this utility,\u00a0 <\/span>is free.\u00a0<\/span><\/p>\n

\"Line<\/a><\/p>\n

Another reason I created this is to demonstrate Azure features that can be used to monitor an environment. \u00a0Once logged with the API Data Collector, the data can be charted in the OMS Workspace as a line chart workspace tile. \u00a0The utility runs as an Azure Automation Runbook on a Hybrid Worker in a central data center.\u00a0 <\/span>All of these technologies have been covered in different videos I have published. \u00a0Links to the resources are at the end of this post.<\/span><\/p>\n

How it Works<\/span><\/h2>\n

Hopefully you will find the utility help, well, helpful. \u00a0At a high level, it pings a group of servers at a given interval and writes the response time to Log Analytics.\u00a0 This utility needs an Azure Log Analytics workspace\u00a0to function.\u00a0 <\/span>If you don\u2019t have a Log Analytics Workspace you are in luck. \u00a0All the information you need to set one up is here<\/a>.<\/span><\/p>\n

There are two inputs for the utility, hours to run and server list. \u00a0Hours to run set the amount of time the script will continue to run.\u00a0 <\/span>Default is one hour. \u00a0With a one hour runtime, the utility will need to be started every hour.\u00a0 <\/span>This will keep it constantly running and prevent gaps in data. \u00a0You could set it to run for 24 and have it start start it once a day.\u00a0 <\/span>However, if there is a problem such as a server restart, you may miss a significant amount of data. \u00a0Running an hour for an hour will minimize the impact if the job ends prematurely.\u00a0<\/span><\/p>\n

The second input is a list of servers. \u00a0You can pass this to the utility when the script runs or set the default value within the utility. \u00a0These are the servers or IP\u2019s the utility will ping and report on.<\/span><\/p>\n

There are two ways to run it, as a scheduled task or on an Azure Automation Hybrid Worker.<\/span><\/p>\n

Scheduled Task<\/span><\/h3>\n

Running as a scheduled task does not require an Azure Automation account. \u00a0Set up the Task Scheduler on the computer you want the ping command to come from. \u00a0Make sure to match the hours to run with how frequently the utility is started. <\/span><\/p>\n

Azure Automation Hybrid Worker<\/span><\/h3>\n

An Azure Automation account and a Hybrid Worker at the source location is required for this configuration. \u00a0The Hybrid Worker has a couple advantages over scheduled tasks such as central job monitoring and the Log Analytics Workspace Key can be secured as an encrypted variable<\/a> in Azure Automation. \u00a0As with the scheduled task option, match the hours to run with how frequently the utility is started.\u00a0 <\/span>Azure Automation will stop scripts that run longer than 3 hours, so keep that in mind when configuring the utility.<\/span><\/p>\n

Note that this utility will not run in Azure. \u00a0It uses the Windows Ping command and that is not a valid command when ran in Azure Automation. <\/span><\/p>\n

The Utility can be found here:
\nhttps:\/\/github.com\/tsrob50\/PingTimeLog<\/a>
\n<\/span><\/p>\n

Additional resources here:
\nYoutube Playlists<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Today I am publishing a utility called PingTimeLog.\u00a0 The idea is simple; ping a group of servers and write the response time to Azure Log Analytics. This utility is intended to be run as a Runbook on an Azure Automation Hybrid Worker. \u00a0Alternatively, it will run as a scheduled task on a server in your …<\/p>\n

Log Ping Response to Log Analytics<\/span> Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[2,252],"tags":[230,9,210,264,265,266,199,263,201,261,20,262,72],"yoast_head":"\nLog Ping Response to Log Analytics - ciraltos<\/title>\n<meta name=\"description\" content=\"the idea is simple; ping a group of servers and write the response time to Azure Log Analytics. This utility is intended to be run as a Runbook on an Azure Automation Hybrid Worker. \u00a0Alternatively, it will run as a scheduled task on a server in your datacenter.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Log Ping Response to Log Analytics - ciraltos\" \/>\n<meta property=\"og:description\" content=\"the idea is simple; ping a group of servers and write the response time to Azure Log Analytics. This utility is intended to be run as a Runbook on an Azure Automation Hybrid Worker. \u00a0Alternatively, it will run as a scheduled task on a server in your datacenter.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/\" \/>\n<meta property=\"og:site_name\" content=\"ciraltos\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-25T01:04:55+00:00\" \/>\n<meta name=\"author\" content=\"Travis Roberts\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ciraltos\" \/>\n<meta name=\"twitter:site\" content=\"@ciraltos\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Travis Roberts\" \/>\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:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/\"},\"author\":{\"name\":\"Travis Roberts\",\"@id\":\"https:\/\/www.ciraltos.com\/staging2\/#\/schema\/person\/25391996d6cddfecd4d257162b7e373a\"},\"headline\":\"Log Ping Response to Log Analytics\",\"datePublished\":\"2018-08-25T01:04:55+00:00\",\"dateModified\":\"2018-08-25T01:04:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/\"},\"wordCount\":756,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.ciraltos.com\/staging2\/#\/schema\/person\/25391996d6cddfecd4d257162b7e373a\"},\"keywords\":[\"Automation\",\"Azure\",\"Azure Automation\",\"azure log analytics\",\"hybrid\",\"hybrid worker\",\"Log\",\"ms\",\"OMS\",\"Ping\",\"Powershell\",\"response\",\"time\"],\"articleSection\":[\"Azure\",\"Azure Automation\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/\",\"url\":\"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/\",\"name\":\"Log Ping Response to Log Analytics - ciraltos\",\"isPartOf\":{\"@id\":\"https:\/\/www.ciraltos.com\/staging2\/#website\"},\"datePublished\":\"2018-08-25T01:04:55+00:00\",\"dateModified\":\"2018-08-25T01:04:55+00:00\",\"description\":\"the idea is simple; ping a group of servers and write the response time to Azure Log Analytics. This utility is intended to be run as a Runbook on an Azure Automation Hybrid Worker. \u00a0Alternatively, it will run as a scheduled task on a server in your datacenter.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.ciraltos.com\/staging2\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Log Ping Response to Log Analytics\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.ciraltos.com\/staging2\/#website\",\"url\":\"https:\/\/www.ciraltos.com\/staging2\/\",\"name\":\"ciraltos\",\"description\":\"cloud, technology and trends\",\"publisher\":{\"@id\":\"https:\/\/www.ciraltos.com\/staging2\/#\/schema\/person\/25391996d6cddfecd4d257162b7e373a\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.ciraltos.com\/staging2\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.ciraltos.com\/staging2\/#\/schema\/person\/25391996d6cddfecd4d257162b7e373a\",\"name\":\"Travis Roberts\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.ciraltos.com\/staging2\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.ciraltos.com\/staging2\/wp-content\/uploads\/2023\/03\/Logo-1.png\",\"contentUrl\":\"https:\/\/www.ciraltos.com\/staging2\/wp-content\/uploads\/2023\/03\/Logo-1.png\",\"width\":5657,\"height\":3563,\"caption\":\"Travis Roberts\"},\"logo\":{\"@id\":\"https:\/\/www.ciraltos.com\/staging2\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/www.ciraltos.com\",\"https:\/\/twitter.com\/ciraltos\"],\"url\":\"https:\/\/www.ciraltos.com\/staging2\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Log Ping Response to Log Analytics - ciraltos","description":"the idea is simple; ping a group of servers and write the response time to Azure Log Analytics. This utility is intended to be run as a Runbook on an Azure Automation Hybrid Worker. \u00a0Alternatively, it will run as a scheduled task on a server in your datacenter.","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:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/","og_locale":"en_US","og_type":"article","og_title":"Log Ping Response to Log Analytics - ciraltos","og_description":"the idea is simple; ping a group of servers and write the response time to Azure Log Analytics. This utility is intended to be run as a Runbook on an Azure Automation Hybrid Worker. \u00a0Alternatively, it will run as a scheduled task on a server in your datacenter.","og_url":"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/","og_site_name":"ciraltos","article_published_time":"2018-08-25T01:04:55+00:00","author":"Travis Roberts","twitter_card":"summary_large_image","twitter_creator":"@ciraltos","twitter_site":"@ciraltos","twitter_misc":{"Written by":"Travis Roberts","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/#article","isPartOf":{"@id":"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/"},"author":{"name":"Travis Roberts","@id":"https:\/\/www.ciraltos.com\/staging2\/#\/schema\/person\/25391996d6cddfecd4d257162b7e373a"},"headline":"Log Ping Response to Log Analytics","datePublished":"2018-08-25T01:04:55+00:00","dateModified":"2018-08-25T01:04:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/"},"wordCount":756,"commentCount":1,"publisher":{"@id":"https:\/\/www.ciraltos.com\/staging2\/#\/schema\/person\/25391996d6cddfecd4d257162b7e373a"},"keywords":["Automation","Azure","Azure Automation","azure log analytics","hybrid","hybrid worker","Log","ms","OMS","Ping","Powershell","response","time"],"articleSection":["Azure","Azure Automation"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/","url":"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/","name":"Log Ping Response to Log Analytics - ciraltos","isPartOf":{"@id":"https:\/\/www.ciraltos.com\/staging2\/#website"},"datePublished":"2018-08-25T01:04:55+00:00","dateModified":"2018-08-25T01:04:55+00:00","description":"the idea is simple; ping a group of servers and write the response time to Azure Log Analytics. This utility is intended to be run as a Runbook on an Azure Automation Hybrid Worker. \u00a0Alternatively, it will run as a scheduled task on a server in your datacenter.","breadcrumb":{"@id":"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.ciraltos.com\/staging2\/log-ping-response-to-log-analytics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.ciraltos.com\/staging2\/"},{"@type":"ListItem","position":2,"name":"Log Ping Response to Log Analytics"}]},{"@type":"WebSite","@id":"https:\/\/www.ciraltos.com\/staging2\/#website","url":"https:\/\/www.ciraltos.com\/staging2\/","name":"ciraltos","description":"cloud, technology and trends","publisher":{"@id":"https:\/\/www.ciraltos.com\/staging2\/#\/schema\/person\/25391996d6cddfecd4d257162b7e373a"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.ciraltos.com\/staging2\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.ciraltos.com\/staging2\/#\/schema\/person\/25391996d6cddfecd4d257162b7e373a","name":"Travis Roberts","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.ciraltos.com\/staging2\/#\/schema\/person\/image\/","url":"https:\/\/www.ciraltos.com\/staging2\/wp-content\/uploads\/2023\/03\/Logo-1.png","contentUrl":"https:\/\/www.ciraltos.com\/staging2\/wp-content\/uploads\/2023\/03\/Logo-1.png","width":5657,"height":3563,"caption":"Travis Roberts"},"logo":{"@id":"https:\/\/www.ciraltos.com\/staging2\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/www.ciraltos.com","https:\/\/twitter.com\/ciraltos"],"url":"https:\/\/www.ciraltos.com\/staging2\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.ciraltos.com\/staging2\/wp-json\/wp\/v2\/posts\/571"}],"collection":[{"href":"https:\/\/www.ciraltos.com\/staging2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ciraltos.com\/staging2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ciraltos.com\/staging2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ciraltos.com\/staging2\/wp-json\/wp\/v2\/comments?post=571"}],"version-history":[{"count":5,"href":"https:\/\/www.ciraltos.com\/staging2\/wp-json\/wp\/v2\/posts\/571\/revisions"}],"predecessor-version":[{"id":579,"href":"https:\/\/www.ciraltos.com\/staging2\/wp-json\/wp\/v2\/posts\/571\/revisions\/579"}],"wp:attachment":[{"href":"https:\/\/www.ciraltos.com\/staging2\/wp-json\/wp\/v2\/media?parent=571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ciraltos.com\/staging2\/wp-json\/wp\/v2\/categories?post=571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ciraltos.com\/staging2\/wp-json\/wp\/v2\/tags?post=571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}