I managed to solve this by using the _mapping api set like this:
GET */_mapping/field/<field-to-look-for>
can also use * with field name in case to match more then one fields with name patterns
It returns the mapping of all the indexes that contain the field name. Than you can import it on python or do some data cleaning with your IDE.
For the other issue in update by query I replied here: in this separate post while looking for help.