Cognos Analytics

Hey all

Is there a way via the logs or Audit that we can determine how many emails have been sent via cognos on a daily or weekly basis?

Cheers

Scott

Hi Scott,

outgoing email addresses are stored in COGIPF_AGENTRUN.COGIPF_EMAIL.

This column is filled per send request, so maybe at lot (or too much for the string column) of email addresses.

From ICALT tool: "select distinct COGIPF_EMAIL as EMAIL from COGIPF_AGENTRUN" and the result is split by comma to get the single email address.

As the most tables this table has also COGIPF_LOCALTIMESTAMP to filter by time.

Michael

Hey all

Is there a way via the logs or Audit that we can determine how many emails have been sent via cognos on a daily or weekly basis?

Cheers

Scott