GREF Email Bot (Existing): User Guide

1. Introduction

Installers and team members (e.g., warehouse staff) can verify device/site health and telemetry status using the GREF-provided email bot. The bot helps ensure that devices are correctly configured, properly installed, and connected, for individual devices or entire sites.

Key reports available via the email bot:

Device Information Report – detailed metadata, health status, and recent telemetry for a single device
Site Report – summary and health overview of all devices at a site

This document covers:

Device provisioning using Milvian-provided data
Accessing gateway certificates and metadata files
Using the email bot to confirm proper installation and configuration

Note: This existing email bot will be gradually replaced by an upcoming initiative involving the Atria migration to GREF, followed by the development of a Device/Site Health app. The new app will consume GREF APIs to provide device and site health, as well as telemetry data.

2. Device Provisioning

Milvian provides GREF with the list and details of gateways and sensors to be provisioned in AWS IoT Core within the GREF AWS accounts. This information is typically shared in CSV or Excel format and uploaded to a designated storage location (e.g., Box).

GREF retrieves this data to provision the devices in their production IoT accounts and also generates the required certificates for gateways.

3. Gateway Certificates & Metadata Access

Once devices are provisioned:

In case of gateways - certificates, keys, and endpoint details are generated
These files are uploaded to GREF’s Prod Hub account and retrieved via Milvian’s Automated Gateway Certificates Retrieval and Distribution System. The system zips the certificates and emails them to the respective shared mailboxes for each warehouse (for now, we use gatewaycerts@milvian.group for all warehouses).

Typical ZIP File Structure for the Certificates

<gateway-eui>/
  ├── <last-5-digits-gateway-eui>.pem
  └── <last-5-digits-gateway-eui>.key
endpoints.json
servertrust.pem

Usage

Milvian uses these certificates and metadata files to:

Configure gateways
Establish secure connectivity to AWS IoT Core

4. Device/Site Health and Telemetry Verification via Email Bot

Installers and other team members (e.g., warehouse staff) can verify device configuration and installation status by sending emails to the GREF-provided email bot. The bot helps check site and device health, as well as telemetry status, and is accessible at:

Email: devicestatus@prod.gtsb.gref.amazon.dev

The email bot responds with either a Device Information Report or a Site Report, depending on the subject line.

4.1 Device Information Report

Used to check detailed device metadata, health status and recent telemetry (last 60 mins) for a single device.

How to Request

Email: devicestatus@prod.gtsb.gref.amazon.dev
Subject: DevEUI (Last 5 characters)
Body: Leave empty

Example

Subject: 07587
Body:

Report Delivery:
Three emails are received at the following intervals:

Almost immediately (~1 minute)
+15 minutes after the first email
+15 minutes after the second email

Response Includes

Device metadata (site, model, serial number, location, etc.)
Health status
Recent telemetry (last 60 minutes)

Sample Output

Note: The fields in the Device Information section are the same across all emails; only their order may differ between instances.

🔧 Device Information Report
Generated: 2026-03-25 20:59:21 UTC

Device Health Status
Healthy (Last updated 9 minutes ago)

📋 Request Details
Site ID:                sea24
Requested Device ID:    00800000D0007587
Full Device ID:         00800000D0007587

🖥️ Device Information
Stage:                  iad-prod
Deviceid:               00800000D0007587
Devicemodel:            MTCAP3-LNA7D-A23UEA-LUM.R1
Devicemake:             MultiTech
Site:                   sea24
Rfregion:               US915
Sensorlocation:         Engineer_Room
Serialnumber:           23425166
Floor:                  P1
Healthstatus:           connected
Devicetype:             WirelessGateway
Healthlastupdatedtimestamp: 1774457819937
Assettag:               G00160010

📊 Recent Telemetry Data (Last 60 minutes)
Deveui             Gatewayeui           Gatewayrssi   Time                 Battery   Metervalue  Metervalue2  Metervalue3  Pulsecount  Pulsecount2  Pulsecount3  Usgallon  Rn
0004a30b0129a6fd   00800000d0007587     -40.0         2026-03-25 20:50:13  3.32     6867.2      0.0          0.0          68672.0     0.0          0.0          None      1
0004a30b0129a6fd   00800000d0007587     -40.0         2026-03-25 20:35:13  3.32     6866.9      0.0          0.0          68669.0     0.0          0.0          None      2
0004a30b012dbeeb   00800000d0007587     -46.0         2026-03-25 20:53:12  3.30     212106.0    0.0          0.0          212106.0    0.0          0.0          None      1

Health Status Legend

🟢 Healthy: Updated within 30 minutes
🟡 Warning: Updated 30–90 minutes ago
🔴 Critical: Updated more than 90 minutes ago

4.2 Site Report

Provides summary and health status of all devices at a site.