Identify all the field changes in a table record

Ra_l Ruvalcaba
Tera Contributor

Hi, i am trying to identify all the changes in a lot of records in a specify table, in this case cmdb_ci_server, the field is state, the discovery made its changes but i need to know the amount of all the records that update the state field, i was searching in the sys_history_line table, but i can't search the records in a massive way, only one by one, for example "state is one of", my question is if exist another way to identify all the records with these changes by field in a table and the date?

 

Regards

Thank you