answered my own question whilst typing that out!

SELECT (select SERVERPROPERTY ('ServerName') ) as [Connection String], [Database Name], [Recovery Model], [Compatibility Level], State, Owner

FROM [Database State]

WHERE ([Database Name] NOT IN ('master', 'tempdb', 'model', 'msdb'))

appreciate your time