Files transfered report using AFT

[k2p6v5s]

Hi All,

I want create a report which has file names transferred by using the FTP account by the end of the day.

ex: FTP account created in ccm(Control-M Configuration Manager) called ftpacnt1.Which transfer files between server1 to server 2.So I want to create a report which has all file transferred successfully or not able transferred also.


Please let me know if more information required.

Any help appreciated.

[Walty]

Hi,

For similar situation sometimes I used this query to identify the 'AFT jobs' (based on CMR_AJF and CMR_SETVAR table)

You found :

- jobname
- the account used --> %%FTP-ACCOUNT
- x local file (full path) --> %%FTP-LPATHx
- x remote file (full path) --> %%FTP-RPATHx
- status for job ENDED-OK
- odate

select A.ORDERNO,JOBNAME,VAR,VAREXPR,STATUS,ODATE
from CMR_SETVAR A, CMR_AJF B
where A.ORDERNO=B.ORDERNO
and B.APPLFORM = 'AFT'
and STATUS='Y'
and A.VAR in ('%%FTP-ACCOUNT'
,'%%FTP-LPATH1','%%FTP-RPATH1'
,'%%FTP-LPATH2','%%FTP-RPATH2'
,'%%FTP-LPATH3','%%FTP-RPATH3'
,'%%FTP-LPATH4','%%FTP-RPATH4'
,'%%FTP-LPATH5','%%FTP-RPATH5')
order by 2,1,3