I found a quicker way to find out that status, I query DATABASEPROPERTYEX, this gives me what I need (simply whether the database is ONLINE/OFFLINE). Now just working out how to wrap in one SELECT, so I can quickly identify the status of each database on the instance.