Automic Workload Automation

Expand all | Collapse all

Details of Connection Objects

Jump to Best Answer
  • 1.  Details of Connection Objects

    Posted 14 days ago
    ​Hi All

    Does anyone have a query to list all the details/values from the connection objects created in the system? Like, port number, server IP address etc.,
    I am only aware that the ONA table has the details, but it has only types not the actual values.


    ------------------------------
    Thanks Shravani
    ------------------------------


  • 2.  RE: Details of Connection Objects

    Posted 13 days ago
    I just spent some time searching the database for this information but so far, I'm stumped too.

    I found this list of RA parameters to be interesting though;

    select * from jppcv
    where jppcv_vname like '%port%'​


    ------------------------------
    Pete
    ------------------------------



  • 3.  RE: Details of Connection Objects
    Best Answer

    Posted 14 days ago
    Edited by Pete Wirfs 13 days ago
    Found it.  I didn't want to give up because I thought it would be a useful query to have.

    select oh_client, oh_name, oh_otype
    	 , (select ocv_value from ocv where ocv_oh_idnr = oh_idnr and ocv_vname = 'operation') as Operation
         , (select ocv_value from ocv where ocv_oh_idnr = oh_idnr and ocv_vname = 'port') as Port
    	 , (select ocv_value from ocv where ocv_oh_idnr = oh_idnr and ocv_vname = 'userId') as Userid
    	 , ona.*
    from ona, oh
    where ONA_OH_Idnr= oh_idnr
      and oh_otype = 'CONN' and oh_deleteflag = 0
    order by 1, 2;
    


    ------------------------------
    Pete
    ------------------------------



  • 4.  RE: Details of Connection Objects

    Posted 14 days ago
    Thank you so much Pete for your time in looking into this. I will try this and also post updates if i find anything too. Its time taking for me as I am not so good at SQL stuff.

    ------------------------------
    Thanks Shravani
    ------------------------------



  • 5.  RE: Details of Connection Objects

    Posted 13 days ago
    Thank you Pete. you are awesome! It worked!  :)

    ------------------------------
    Thanks Shravani
    ------------------------------