Orphaned hardware inventory?
Has anyone ever seen an issue where devices exist in, say, Computer System hardware inventory but nowhere else? I have a client doing some cleanup of older models and when we query the DB (v_gs_computer_system) we see for example 4 devices for one model, but the corresponding model collection based on the same data is empty. Turns out when I look for these devices by hostname or resource ID, they're nowhere to be seen - not in the console, nor in v_r_system. I've checked a few other views like v_gs_pc_bios, v_gs_add_remove_programs and it looks to be the same so probably not specific to computer_system but it's an easy one to validate on.
They have about 200 objects like this out of ~10k and all the affected timestamps on the hardware inventory are 2-3 years old so nothing recent. I'm curious how this happened and if anyone else has seen this. Obviously I'm not going to YOLO in and delete anything from the DB, it isn't really causing any harm as far as I can see other than potential confusion and so long as you're joining to other tables where the devices don't exist it's kind of irrelevant, but it is odd. All cleanup tasks are running as they should be. Probably would raise a case with MS if I had the time to burn.
Example query just in case anyone else wants to check:
select CS.ResourceID, CS.Name0, CS.Model0, CS.Timestamp
from v_GS_Computer_System CS
where CS.ResourceID not in (
select vrs.ResourceID from v_r_system vrs
)