SELECT
	D.[name]
	,CASE WHEN LS.primary_database IS NOT NULL THEN 1 ELSE 0 END AS is_log_shipped
FROM
	sys.databases D
LEFT OUTER JOIN
	msdb.dbo.log_shipping_primary_databases LS
ON
	D.[name] = LS.primary_database