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
------------------------------
Michael Haaß
IBM
------------------------------
Original Message:
Sent: Thu June 27, 2024 08:53 AM
From: Scott Hughes
Subject: Email Audit
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
------------------------------
Scott Hughes
------------------------------