How to change Page Refresh Interval for All Users

[cacti_is_awesome]

Hi,

I've created network weathermap for my network. Now I want to change default "Page Refresh" interval from 300 seconds to 200 seconds for all the users.

I can certainly change it for few users, but there are more than 100 users here.

See attached for more information.

Is there a way to do it for all users either by editing a file or by updating a table in cactidb?

Thanks,
Ray

[Linegod]

Code: Select all

update settings_graphs set value=200 where `name`='page_refresh';

[cacti_is_awesome]

Code: Select all

update settings_graphs set value=200 where `name`='page_refresh';

Thanks for the SQL query. It updated only 20 rows, against 375 users I have.

Any idea why few users show up when you query "settings_graphs" table using below query?

select user_id from settings_graphs where name='page_refresh';
+---------+
| user_id |
+---------+
| 1 |
| 18 |
| 33 |
| 48 |
| 50 |
| 51 |
| 52 |
| 54 |
| 82 |
| 88 |
| 92 |
| 164 |
| 225 |
| 227 |
| 247 |
| 262 |
| 272 |
| 324 |
| 333 |
| 335 |
+---------+
20 rows in set (0.01 sec)

[Linegod]

Their settings have not been adjusted, so they will use the site default.

[Linegod]

Just to be clear, not 'default', but whatever is set on the global Settings.