Manage incident reporting in PagerDuty and CrateDB

This workflow automatically monitors the functionality of a factory. The workflow logs machine data coming from factory sensors in a CrateDB database, generates an incident report in PagerDuty, and notifies the responsible staff members when the temperature of a machine crosses the threshold value.

This workflow builds on a workflow that generates factory data.

Read more about this use case and how to build both workflows with step-by-step instructions in the blog post How to automate your factory's incident reporting.

Prerequisites

• A PagerDuty account and credentials
• AMQP, an ActiveMQ  connection, and credentials
• A CrateDB instance running locally or on a server, and credentials.

Nodes

• AMQP Trigger node starts the workflow.
• IF node filters sensor values higher than 50°C.
• PagerDuty node creates an incident in the account.
• Set nodes set the required incident information and sensor data, respectively.
• CrateDB nodes ingest the information data and machine sensor data, respectively.
• Function node converts degrees from Celsius to Fahrenheit.