How to determine if orphaned records exist in the asset table - Support and Troubleshooting

How to determine if orphaned records exist in the asset table Issue Several asset records that are linked to a CI are reporting the Record is not found. Also, from the CI stand point the Asset record is reporting the same issue. Steps to reproduce: 1. Navigate to Asset > All Asset 2. Open a Asset Record 3. Go to the CI and open that record. You will see this message, “Record is not found”, which it should show were the table it should exist in. (capture the sys_id.) Go to the table and search for that sys_id Vice versa from the CI record, go to the Asset record and capture the sys_id and search for that in the ‘alm_hardware' list. Cause Potential root cause 1. Gather the sys_id of that missing record 2. Go to that table and search for that sys_id 3. Go to the Audit trail history of that record. Was there any change to the sys_id? It should list a change of the sys_id and by who and perhaps someone may have deleted this record. Or possibly during the asset creation phase, an invalid CI - sys_id was added. Also a good place to investigate this issue would be in the delete history. If there is a sys_id that is either from the asset or CI record stand point that needs to be linked, you can create a script to tie in these together. Or start from scratch with creating a new Asset with a CI.