SQL query gone banans

[BOS_Hovgaard]

This SQL statement is executed somewhere:

SELECT COUNT(1) AS total FROM web40repsoftchangeslast7day

This view contents is in the attached file:

This cause my SQL server to go bananas in the Temp base and fill it up. I ran the
query an the result is 1.000.000 rows where most of it is a identical row repeated a lot of times.
This is not something I have made, it must be part of the standard package. Any ideas what to do?

[Obi_1_Cinobi]

Hello there!

We recommend contacting support if you require further assistance with this: https://www.lansweeper.com/contact-support/

[rader]

Looking at the results of the query, I'd have limited the Select Top statement to 1000 vs 1,000,000. This at least limits the temp base fill up if your testing out a new query.

My run shows that the only changed fields for the duplicates was the Install Date.

From here you should be able to limit the results and fine tune the query for your needs.