Identify User who triggered OBIEE Agent

Question

Hi,

Oracle Business Intelligence 12.2.1.1.0

We have scheduled agents saved in folder where lot users have access to. Users have the privilege to run the Agent. Is there a way to identify which user triggered the agent ?

Thanks

Ebin

Syedsalmancs110 · Answer

Hi Ebin,

Did you try to explore more on BIPLATFORM schema tables S_NQ_ACCT(Analytics Usage Tracking Table) and S_NQ_JOB(Scheduler table), to find out if a join between these two table may provide you with required information, I have not tested it myself but just a thought as I think its possible to get the information you are looking for using these two tables.

Thanks,

Ebin Cherian · Answer

Hi Asim,

Thanks for your reply.User ID shows the user who is selected in the Run as Specified user section. I want to see the user who triggered the agent.

For example.. say agent 1 is created and in that user 1 is selected in the run as specified user section. User 2 triggered agent 1. My question is where can I find agent 1 was triggered by User 2 ?

asim cholas · Answer

Open the job manager and check.