Solved

HF version of an Astea Customer Database

2 years ago
August 3, 2022
2 replies
65 views

+6

Githmi Gamage
Hero (Employee)
13 replies

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%'

View original

Did this topic help you find an answer to your question?

+9

Pranavan Paranthaman
Hero (Employee)
63 replies
Answer
2 years ago
August 3, 2022

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%'