Find file version through script and command

Check file version in application through sql script & linux/sun os command.

Enter file name in below script which provide file version with location.

  SELECT af.app_short_name "Application",
         af.filename "File Name",
         MAX (afv.VERSION) "File Version",
         af.subdir "Location"
    FROM apps.ad_files af, apps.ad_file_versions afv
   WHERE af.filename = '&filename' 
GROUP BY af.filename,
         afv.VERSION,
         af.app_short_name,
         af.subdir
ORDER BY afv.version DESC;

Reach to the location of file and grep the header of the file where file version is provided.

strings -a $AP_TOP/apcrtdmb.pls |grep '$Header'

Find file version through script and command

Tags