Check who has received an agent

Bobby Jourdan · Mar 26, 2025 9:47AM

Summary:

Content (please ensure you mask any confidential information):

Hi there, is there a way to see who has received an agent that I have set?

Thanks

Bobby

Version (include the version you are using, if applicable):

24D

Code Snippet (add any code snippets that support your topic, if applicable):

gclampitt · Mar 28, 2025 7:29AM

Hello several posts about this subject already on this forum.
This one says not possible and includes link to idea to vote

https://community.oracle.com/products/oracleanalytics/discussion/22756/cloud-fusion-bi-publisher-ways-to-confirm-if-the-email-from-bursting-was-actually-sent-out-or-not

Bobby Jourdan · Mar 28, 2025 7:41AM

thanks @gclampitt although I see the posts and the idea are about the BI reporting. I actually meant the OTBI agents. Does that make any difference or the answer is the same?

gclampitt · Mar 28, 2025 9:33AM

hiya yeah, i've not been able to find anything for OTBI myself.

For on-premise, could query the the Agent table, S_NQ_JOB - but even this only had details such as job name, run date etc….didn't have details of Emails sent.
And assuming this table still exists in cloud, can't find a way to query it.
Can look at the usage table S_NQ_ACCT via the "OTBI Usage Real Time" SA, but can't see anyway to query the Job table

Oracle Transactional Business Intelligence

Categories

Check who has received an agent

Answers