SYSSUBSCRIPTIONS system view

CREATE VIEW SYS.SYSSUBSCRIPTIONS
AS
SELECT(select publication_name 
		FROM SYS.SYSPUBLICATION AS p
		WHERE p.publication_id=s.publication_id) AS 
		publication_name,
		(select user_name FROM SYS.SYSUSERPERM AS u
		WHERE u.user_id=s.user_id) AS user_name,
		subscribe_by,created,started 
FROM SYS.SYSSUBSCRIPTION AS s

Presents subscription information, such as the publication name, creation time, and start time from the SYSPUBLICATION table in a more readable format.