Solved

How to know all settings existing in Setup History Log

  • 12 December 2021
  • 2 replies
  • 186 views

Userlevel 4
Badge +10

Hi ! Everybody, Is there anyone can help me on this topic?

I USE IFS8. In function Solution Manager\Configuration\Logs and Queues\Setup History Log, how can I see all settings existing quickly? So I know if they is the log setting already which I want. Otherwise I have to take about 3 minutes to find the component, table and field. 

 

 

And is there anyone can give me a simple instruction on how to choice Sub forum? I really don’t know which sub forum should I select for this question.

 

icon

Best answer by ShawnBerk 13 December 2021, 01:03

View original

This topic has been closed for comments

2 replies

Userlevel 7
Badge +28

You should be able to run this from the SQL Query Tool or a Quick Report to see all of your settings.

 

select
hs.table_name,
hs.activate_cleanup,
hs.days_to_keep,
hsa.column_name,
hsa.log_delete,
hsa.log_insert,
hsa.log_update
from [yourinstance].history_setting_tab hs
LEFT JOIN [yourinstance].history_setting_attribute_tab hsa
ON
hs.table_name = hsa.table_name
ORDER BY hs.table_name

 

Framework & Experience is probably the correct sub-forum.

Userlevel 4
Badge +10

You should be able to run this from the SQL Query Tool or a Quick Report to see all of your settings.

 

select
hs.table_name,
hs.activate_cleanup,
hs.days_to_keep,
hsa.column_name,
hsa.log_delete,
hsa.log_insert,
hsa.log_update
from [yourinstance].history_setting_tab hs
LEFT JOIN [yourinstance].history_setting_attribute_tab hsa
ON
hs.table_name = hsa.table_name
ORDER BY hs.table_name

 

Framework & Experience is probably the correct sub-forum.

Thank you very much!

BR

Bright Zhao