Type
  • Best practice
Description
  • This article explains how to process the text output from a Monitor with Monitoring Studio X.
Additional Keywords
  • Monitoring Studio X, JSON Parsing, REST API, Dynamic Object, Value Map

Related Topics

Knowledge Base

Text Processing with Monitoring Studio X

KB1253 - Jun 20, 2019

Introduction

Monitoring Studio X provides several Monitors to get the data through HTTP REQUEST, COMMAND LINE, etc. This article explains how to configure the Text Pre-Processing Analysis when a Monitor returns an output in JSON format.

Procedure

In this article, we process the JSON output returned by an HTTP REQUEST Monitor using the TEXT PRE-PROCESSING Analysis to convert the JSON output into CSV format. From the processed output, we create DYNAMIC OBJECTS and for each dynamic instance a VALUE MAP.

  1. Launch the Monitoring Studio X Web Interface
  2. Add the Host on which the Template will be applied if not done already
  3. Create or Edit your Template:
    • Provide the Template Name, Host System Type and other required details
    • Activate this Template on the Host to be monitored
  4. Configure the Monitor:

    • Edit the Template and add the Monitor (HTTP REQUEST, COMMAND LINE, etc.)
    • Perform a Dry Run and check if you get the desired output
    • Save the Monitor if the Dry Run succeeds
    • Copy the output to a JSON browser or any text editor supporting JSON format (Ex. Notepad++ with JSON Plugin)

      JSON Data

    • Identify the metrics you need and find the lowest level in the data structure. In this example, the value to be retrieved is for stateUnknown which is an attribute of an object under the array linksState. Note that linksState is a sub array of groupsState. We will extract the stateUnknown value of a link along with its groupUID which is found under groupLinkUID.

    • Now under the parent Monitor (i.e. HTTP Request or CMD Line), add a TEXT PRE-PROCESSING under New Analysis and add Transformation of type Convert JSON to CSV

      JSON to CSV

    • Perform a Dry Run and click on CREATE if it succeeds

    • Now, add DYNAMIC OBJECT on the JSON to CSV TEXT PRE-PROCESSING created in the previous step using the second column value groupUID/id (%{2}) as the identifier. This will create dynamic objects for each link instances for each group present.

      Dynamic Instances

    • On the DYNAMIC OBJECT created in the previous step, add a VALUE MAP to retrieve the status from column 3

      Value Map

    • Save your Template.

If you think your Template can be useful to others, please share it on GitHub.