How to Identify Frequently Dropped and Constant Offline Devices among 50,000 Devices

Monitor the Device Status Change Using the Rule Engine

1) Online and Offline Status Messages

When a device connecting to the IoT platform goes offline, a message of a specific topic is generated to signify the device status change. Easily learn about the device status change by subscribing to this topic on the server.

1.1 Format of the Online/Offline Status Change

The following table shows the Payload Data Format Parameter description.

2) Configure the Rule Engine to Change the Device Status

2.1 Configure SQL

Next, configure SQL to retrieve the device status, currentTime, and lastTime from the message body. The following snapshot shows the data processing interface of the rule engine.

2.2 Configure Data Transmission RDS

The following snapshot shows how to configure the Data Transmission RDS in a data transmission interface of the rule engine.

In the device_status_history table, run SQL statements to display the online and offline statistics about the device:

2.3 Configure Data Transmission OTS

Now, configure the Data Transmission OTS as shown below.

When a device goes online, transmits service data, and then goes offline, the following records are generated in the table. The Status column indicates the device status, lastTime indicates the last communication time, and currentTime indicates the time when this message is generated, which equals to the online or offline time.


Tracking the status change of IoT devices in real-time helps to ensure hassle-free functioning of IoT devices. This article comprehensively outlines the steps to effectively monitor whether the IoT device is online or offline using the rule engine. For more details, visit .

Original Source:




Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Find area of container with most water in O(n) time and O(1) space

6 Pandas tricks you should know to speed up your data analysis

Technical Support — Survival Guide

SkyDNS: A Method of DNS Service Discovery

How to Synchronize Data from Hive to MaxCompute?

Program 26/1/22_0

Introducing DashboardFox: Business Intelligence Software With No Subscriptions

DashboardFox - Alternative to Power BI and Tableau

Meta Software Engineer Interview Guide

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alibaba Cloud

Alibaba Cloud

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:

More from Medium

Splunk Phantom REST API Filters

Deep Dive into Google’s AlloyDB Architecture for PostgreSQL

Understanding Kubernetes Multi-Container Pod Patterns and Init- Containers

Automating Container Deployment to ECS Using Bitbucket Pipeline