What is the table name(s) that maintains the Historical changes on a Product, PUR, Article

Document ID : KB000118499
Last Modified Date : 25/10/2018
Show Technical Document Details
Question:
I would like to know the table in the database that maintains the historical changes in CA Software Asset Manager 4.2.4.
Answer:
The changes are stored in the table products_h.

In order to see the historical changes for a particular product, run the following:
select * from products_h where orig_product_id = (select product_id from products where description = 'product name') 

Replace product name with the exact product name you are clicking on History for.