List all Databases and Last Full Backups

CREATE PROCEDURE check_backups
AS

SET NOCOUNT ON
select 'Databases and backups on server ' + @@servername
select SUBSTRING(s.name,1,40)AS'Database',
CAST(b.backup_start_date AS char(11)) AS 'Backup Date  ',
CASE WHEN b.backup_start_date > DATEADD(dd,-1,getdate())
THEN 'Backup is current within a day'
     WHEN b.backup_start_date > DATEADD(dd,-7,getdate())
THEN 'Backup is current within a week'
     ELSE '*****CHECK BACKUP!!!*****'
END
AS 'Comment'

from master..sysdatabasess
LEFT OUTER JOINmsdb..backupset b
ON s.name = b.database_name
AND b.backup_start_date = (SELECT MAX(backup_start_date)
FROM msdb..backupset
WHERE database_name = b.database_name
AND type = 'D')-- full database backups only, not log backups
WHEREs.name <> 'tempdb'

ORDER BY s.name