MySQL - Return Undetermined Number of Columns in a Single Row, related to a common key

I have many devices connected by a mesh network. Each device has a serial number. Each device sends out an hourly message to say "I'm still here." The server records periods during which it did not receive that message, a state we call "stale".I have many devices connected by a mesh network