Hi Githmi,

You can use the below SQL query to check last version of hot fix applied on the customers database.

SELECT [ap_descr]
      , ap_glb_param_code]
      , ap_glb_param_id]
      , ap_glb_param_val]
      ,/ap_module_name]
      ,blast_change_by]
      ,ylast_change_at]
      ,eap_descr_lang1]
      ,rap_descr_lang2]
      ,eap_descr_lang3]
      ,pap_descr_lang4]
      ,,ap_descr_lang5]
  FROM Âdbo].pap_glb_param]
  WHERE ap_descr LIKE '%vers%'
 

 

@Phil Seifert also posted a nice article on this way back check it out  
 Alliance database profile - what version Alliance/Hotfix? | IFS Community