If you have the Data Explorer plugin installed on your site, you can get a list of users who have not responded to the activation email with the following query:
SELECT
u.id AS user_id,
email
FROM users u
JOIN user_emails ue
ON ue.user_id = u.id
WHERE u.active = false