Skip to main content

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.

 

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.

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

Terms & ConditionsCookie settings