Skip to main content
Solved

HF version of an Astea Customer Database

  • August 3, 2022
  • 2 replies
  • 75 views

Githmi Gamage
Hero (Employee)
Forum|alt.badge.img+6

Hi All,

How to check the HF version of an Astea Customer Database?

Best answer by Pranavan Paranthaman

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]
      ,[last_change_by]
      ,[last_change_at]
      ,[ap_descr_lang1]
      ,[ap_descr_lang2]
      ,[ap_descr_lang3]
      ,[ap_descr_lang4]
      ,[ap_descr_lang5]
  FROM [dbo].[ap_glb_param]
  WHERE ap_descr LIKE '%vers%'

 

Query Output

 

2 replies

Pranavan Paranthaman
Hero (Employee)
Forum|alt.badge.img+10

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]
      ,[last_change_by]
      ,[last_change_at]
      ,[ap_descr_lang1]
      ,[ap_descr_lang2]
      ,[ap_descr_lang3]
      ,[ap_descr_lang4]
      ,[ap_descr_lang5]
  FROM [dbo].[ap_glb_param]
  WHERE ap_descr LIKE '%vers%'

 

Query Output

 


Pranavan Paranthaman
Hero (Employee)
Forum|alt.badge.img+10

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