similar to the job search string... it is just slightly modified
jobdtl_params will contain the FTP Host information that would be pretty straigh forward
jobdtl_params like '%%'
However the FTP or Runtime users are trickier
you need job_proxy and job_proxy2 from jobdtl table to get the FTP User
in the case of FTP jobs you need to go after job_proxy2 for the FTP User
(NOTE: if you have the data model help file from tidal it says it's the runtime user but it doesn't seem that that is true for FTP jobs its the FTP user)
if you have a user ID you know you are looking for you can get add the ID and use that in your criteria
Where
jobdtl_proxy2 = ###
you can search the usrmst table for the ID's you want
select
usrmst_id,usrmst_name from usrmst
where
usrmst_name like
if you use inheritance for FTP user it gets far trickier
'%< FTP user or part of FTP user you want>%'