Update Table with Network Client Connection Status, I need help with DB design. SQL 2008 Ex R2
On the Devices table, add two fields: LastStatus and LastDateTimeChecked.  Update it whenever you insert records into the Connections table.  The Connections is your history, but you shouldn't be hitting it for live reporting queries.