Eventlog Alerts: Query timeout expired

[audiorapture]

I wanted to look into configuring Eventlog alerts, but when I click on the tab (Reports & Alerts - Mail alerts - Eventlog alerts) I get the following error message: (Lansweeper Configuration) "Query timeout expired."
The same happens for "Eventlog ignore".

We have 4.0.0.41 on a single computer. The configuration utility is 4.0.0.116. There are 152 computers in the Lansweeper database across 2 domains.

What can I do to resolve this?

[Hemoco]

On which hardware are you running the database server?
With 152 computers it should only take a millisecond.

[audiorapture]

Ran the script successfully, now it opens, but it takes a good 5 minutes. Why does this take so long?

[Hemoco · Accepted solution]

you can try a rebuild of all indexes.

In the sql scripts tab:

execute psysrebuildallindexes