Get hostname from an FTP RA Connection Object

[Legacy User]

I'm looking to retrieve the hostname from a given FTP Connection Object. Is this a possibility ? I'm not seeing any documentation around the attributes or the function that would be used to do this. Any information would be appreciated.

[Anon Anon]

There does a script command get_connection exist but unfortunately for DB connections only.

So even via SQL its a bit tricky - you can use this one (T-SQL) for testing purposes:

select ocv_vname, OCV_VALUE from OCV
where ocv_OH_idnr = (select OH_IDNR from OH where OH_CLIENT = 1 and OH_deleteflag = 0 and OH_NAME = 'CONN.FTPAGENT.XLIGHT')

please modify OH_CLIENT = 1 and OH_NAME = 'CONN.FTPAGENT.XLIGHT' accordningly.