Perfect that's work !
I have an other problem due to this modification...
If you want, I want to add the "Location" field, but sometimes I have more than 1 Location by SerialNumber (error I want to fix).
I'm trying to make a count, but it's doesn't work.
| stats count by SERIAL_NUMBER, Location | eval flag=if(Same_SN=1,1,if(Same_SN=0 and count>1,2,0))
Do you have an idea for how to count put 2 if I have more than 1 location ? Or have I to create a new "request" ?
Thanks,
Maxime.
... View more