Timeline of Iot edge reported clients status

How can I draw (I mean, get data to draw) a timeline of IotHub device client connection state?

I would like to draw an availability status timeline from all my devices, for that I am doing the following:

• Every one minute: Request all '$edgeHub' Module Identity Twin
• Save the '$edgeHub' reported clients on a database
• Get a timeline from this database

When my number of devices grows I will do a lot of requests, I was wondering if there is no other optimized way to do it using Azure IoT resources.

From '$edgeHub' module Twin I get the sample:

"reported": {
  "clients": {
    "iot/device": {
      "status": "Connected",
      "lastConnectedTimeUtc": "2020-11-30T12:00:41.5918442Z",
      "lastDisconnectedTimeUtc": "2020-11-30T12:00:41.5737114Z"
    }
  }

For API calls I am using https://github.com/amenzhinsky/iothub

Appreciate any response that helps me to investigate more about Azure monitoring device status.

1. Query

Instead of requesting all the module twins one by one, I would opt for using an IoT Hub query.

SELECT * FROM devices.modules WHERE is_defined(properties.reported.clients)

I don't know if your SDK supports that, but most (if not all) of the official SDKs have support to run queries. This will return every module twin that has the clients reported property defined. You could run that on a schedule and then save that output to a database as you had originally planned.

2. Route all module twin events to an endpoint

This one is a bit more tricky, but you can route device/module changes based on a query. You can then route all the events to a separate endpoint. The route would be something like:

IS_OBJECT($twin.properties.reported.clients)

You can read more on message routing here. The benefit of this approach is that you don't do any requests to IoT Hub and receive changes real-time. You can even consume these events using Azure Stream Analytics, which supports output to Power BI, Table storage and Cosmos DB natively. Result: you wrote no code and used only Azure services. You might want to consult the Azure pricing calculator if you want to leverage Azure Stream Analytics though.

Note: I did not thoroughly test solution #2, but theoretically this should work.