⚒️ Manage incident reporting in PagerDuty and CrateDB
⚡ 1,034 views · ⚒️ Engineering
Description
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.
🔗 Nodes Used
Function, AMQP Trigger, PagerDuty, CrateDB
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File