Reset column view, Zabbix 8.0

SELECT idx,idx2,userid FROM profiles WHERE value_str LIKE '%columns%';

Replicate "Monitoring => Hosts"

UPDATE profiles SET value_str=(
SELECT value_str FROM profiles WHERE idx='web.monitoring.hosts.datatable' AND idx2=0 AND userid=1
) WHERE idx='web.monitoring.hosts.datatable' AND idx2 NOT IN (0) AND userid=1;

Replicate "Monitoring => Problems" page:

UPDATE profiles SET value_str=(
SELECT value_str FROM profiles WHERE idx='web.monitoring.problem.datatable' AND idx2=0 AND userid=1
) WHERE idx='web.monitoring.problem.datatable' AND idx2 NOT IN (0) AND userid=1;

Replicate "Monitoring => Latest data" page

UPDATE profiles SET value_str=(
SELECT value_str FROM profiles WHERE idx='web.monitoring.latest.datatable' AND idx2=0 AND userid=1
) WHERE idx='web.monitoring.latest.datatable' AND idx2 NOT IN (0) AND userid=1;

Set static:

 UPDATE profiles SET value_str='{"columns":[{"id":"name","overrides":{"width":"117px"},"resized":true,"width":"273px"},{"id":"interface","overrides":{"width":"69px","visible":false},"resized":true,"visible":false,"width":"69px"},{"id":"availability","overrides":{"width":"79px","visible":false},"resized":true,"visible":false,"width":"79px"},{"id":"tags","overrides":{"width":"76px","visible":false},"resized":true,"visible":false,"width":"76px"},{"id":"tagvalue"},{"id":"status","overrides":{"width":"57px","visible":false},"resized":true,"visible":false,"width":"57px"},{"id":"latest_data","overrides":{"width":"81px"},"resized":true,"width":"251px"},{"id":"problems","overrides":{"width":"102px"},"resized":true,"width":"241px"},{"id":"graphs","overrides":{"width":"59px"},"resized":true,"width":"203px"},{"id":"dashboards","overrides":{"width":"87px"},"resized":true,"width":"202px"},{"id":"web","overrides":{"width":"78px","visible":false},"resized":true,"visible":false,"width":"78px"},{"id":"custom_text"}],"options":{},"sort_field":"name","sort_order":"ASC"}' WHERE idx='web.monitoring.hosts.datatable';