1 Reply Latest reply: Sep 16, 2013 11:25 PM by HimanshuP RSS

    How to find the host name from which a session is executed?

    6dfcf631-7449-435a-8540-a3f567ba5773

      Hi,

       

      Is there any way through which I can find from which ODI client host name/Ip address a particular scenario was called? Does ODI store any execution plan or anything similar to this that would keep the execution details in detail? Is there anything that would contain the host machine name or IP in which client is set up and the particular scenario is called from?

        • 1. Re: How to find the host name from which a session is executed?
          HimanshuP

          Is there any way through which I can find from which ODI client host name/Ip address a particular scenario was called?

          Host ip is stored in SNP_HOST table of master repository schema but which scenario is executed by which host this could be very typical but you can find by other way which USER executed  which scenario by analyzing of SNP_SESSION.

          Does ODI store any execution plan or anything similar to this that would keep the execution details in detail?

          if you are asking for scheduling then, for this you can check SNP_PLAN_AGENT table in work repository.

           

          let me know

           

          Thanks