How to find the recovery mode for each database ?

Through Below query we can find out the recovery model of SQL Server Databases:-

select [name], DATABASEPROPERTYEX([name],’recovery’) As RecoveryMode
from sysdatabases
where name not in (‘master’,’model’,’tempdb’,’msdb’) –Excluding system databases.