Contains one row per page that failed with a minor 823 error or an 824 error. Pages are listed in this table because they are suspected of being bad, but they might actually be fine. When a suspect page is repaired, its status is updated in the event_type column.
SELECT DB_NAME(database_id) AS [Database Name] ,[file_id] ,page_id ,event_type ,error_count ,last_update_date FROM msdb.dbo.suspect_pages WITH (NOLOCK) ORDER BY database_id OPTION (RECOMPILE);