The query below will provide a report of what pages portal users are subscribed to receive alerts upon changes.
The text in red may need adjusted to reflect the appropriate database naming convention.
subinfo.name as 'Subscribed to',
subinfo.ResourceType as 'Resource Type'
FROM [Production_Portal_PortalFx].[dbo].[ResourceSubscriptions] as SubInfo
left join (Select * from Production_Portal_PortalFx.dbo.PWUser) as UserInfo on userInfo.UserID = subinfo.UserID