After upgrade, some of the CMDB extended tables does not return records properly while running reports and in the list view.
All available releases
CMDB table has number of partitions at the database level. There is a chance that these partitions may become out of sync after upgrade or a similar major change.
The user needs to verify if the query should actually return any records by checking the database. Once you verify the same, you need to run the following script to get the CMDB partitions in sync.
This script can take a few minutes to run depending on the size of the CMDB partitions.