Hi @Gambit_Support,
I would recommend a creating a workflow beginning with a Timer Node for your period of interest (minute, hour, day). Then you could use a Device: Get Node to query your devices by tag (or the Losant API Node if tags are unavailable), and the connection information will be available for each device:
This way you would be able to count the number of connected devices with the connected
boolean, as well as see the last connected time.
For your serial numbers, we recommend using the Data Table for non-state data, and reporting device data as state. Could you explain your use case on the serial numbers a bit further? I want to ensure I recommend the correct solutions to fit your goal.
Thanks!
Julia