BRMS - when IFS object was saved

By kimot, 13 December, 2023

If you want to know when specific object or objects in specific folder was saved. I didn't find answer in BRMS but with little help from SQL you can get answer.

SELECT DINAME as Path, LINAME AS File, LITYPE as File_Type, LISASP as ASP, LISOWN as Owner, LISIZE as Size, 
       DILNAM as BRMSList, DISVT as SaveDate, BKVOL as Volume, BKHSYS as System, BKHSRL as Release, BKLSEQ as Sequence, 
       BKHDEV as Device, BKHEXP as Expiration, BKHGRP as ControlGroup, BKHMC as MediaClass, BKHDUP as Duplicate, 
       BKNAME as JobName, BKJNBR as JobNumber, BKUSER as JobUser
FROM QUSRBRM.QA1ALI2 LEFT OUTER JOIN QUSRBRM.QA1ADI2
  ON QA1ALI2.LIDKMAIN=QA1ADI2.DIDKMAIN AND QA1ALI2.LIDKSYS=QA1ADI2.DIDKSYS AND QA1ALI2.LIDKJNBR=QA1ADI2.DIDKJNBR 
  JOIN QUSRBRM.QA1AHS
  ON QA1ALI2.LIDKMAIN=QA1AHS.BKDKMAIN AND QA1ALI2.LIDKSYS=QA1AHS.BKDKSYS AND QA1ALI2.LIDKJNBR=QA1AHS.BKDKJNBR
WHERE DINAME like '/IDAT001/sftp_trf%'
AND LINAME like 'S160%'
ORDER BY DIPROC DESC;

Result can be something like this :

PATH               FILE  FILE_TYPE  ASP  OWNER     SIZE  BRMSLIST  SAVEDATE        VOLUME  SYSTEM  RELEASE  SEQUENCE    DEVICE    EXPIRATION  CONTROLGROUP   MEDIACLASS  DUPLICATE  JOBNAME   JOBNUMBER  JOBUSER 
/IDAT001/sftp_trf  S160  *STMF      1    OPERATOR  8192  LINKSRV   12312130003737  AS0180  IBMS1   V7R4M0   0000002722  TS4300_A  1240216     S1_SRVSAV      LOCA_SHORT  N          SERV_SAVE 188052     OPERATOR
/IDAT001/sftp_trf  S160  *STMF      1    OPERATOR  8192  LINKSRV   12312130003737  AS0180  IBMS1   V7R4M0   0000114206  TS4300_B  1240216     S1_SRVSAV      LOCB_SHORT  Y          SERV_SAVE 188052     OPERATOR
/IDAT001/sftp_trf  S160  *STMF      1    OPERATOR  8192  LINKSRV   1231203040835   AS0158  IBMS1   V7R4M0   0000001925  TS4300_A  1240206     S1_SRVSAV      LOCA_SHORT  N          SERV_SAVE 52752      OPERATOR