Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Identify User who triggered OBIEE Agent

Received Response
21
Views
3
Comments
Ebin Cherian
Ebin Cherian Rank 5 - Community Champion
edited Aug 13, 2024 5:57PM in Oracle Analytics Forum

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

Answers

  • asim cholas
    asim cholas Rank 6 - Analytics & AI Lead

    Open the job manager and check.

    pastedImage_2.png

  • Ebin Cherian
    Ebin Cherian Rank 5 - Community Champion

    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 ?

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics & AI Lead

    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,