sachin_namjoshi
Mega Patron

sys_history_line is part of table rotation which happens every 7 days.

So, querying sys_history_line won't help you since this table is rotated every 7 days.

Also, you may get performance issues if you query sys_audit, sys_history_line table due to huge number of records.

 

Instead, i will suggest you to load renamed CI data using data sources, transform maps.

Building spreadsheet with renamed CI will be little painful but this will be one time.

 

Regards,

Sachin