How to get reports about how many emails have sent to users

[former_member847841]

Hi,

Is it possible to get the reports from SAP CDC about how many password reset emails were sent and in those emails no.of clicks on password reset button?

[Oleh_Ilchyshyn1]

Hi Maheswari K,

"Is it possible to get the reports from SAP CDC about how many password reset emails were sent" - Not specific tool or counter for this, but yes, it is.
Audit Log functionality can help you here.
To check it, you can use UI part of Console or audit.search REST API with the following query:

// If you need objects itself(including count in the end of the response)
SELECT * FROM auditLog WHERE endpoint = 'accounts.resetPassword' AND errCode = 0 AND params.sendEmail != false AND params.passwordResetToken is null

// If you need  just count
SELECT count(*) FROM auditLog WHERE endpoint = 'accounts.resetPassword' AND errCode = 0 AND params.sendEmail != false AND params.passwordResetToken is null

"Is it possible to get in those emails no.of clicks on password reset button?" - As I know CDC doesn't support it OOTB, but I see the next workaround you can use:
Audit Log functionality can help you here as well.

SELECT * FROM auditLog WHERE endpoint = 'accounts.resetPassword' AND errCode = 0 AND (params.passwordResetToken is not null AND params.newPassword is not null)

In the response you will get profiles and their UIDs who successfully reseted the password.

=====================================================================

You also can automate the process base on APIs/queries above and create Data Flow which will be handling everyday users and check if they got an email and whether then managed to reset the password or not.

Hope it has helped you and given a direction to deep dive into this.

[SebastianSchuck19]

It should be noted that this only works if you are not calling accounts.resetPassword another way (beside email).

Otherwise great answer!