I have 82421 collectible DCIs and an additional 25552 that are missing a corresponding node.
nxdbmgr check does not find and purge these.
There do not appear to be any leftover data in the corresponding idata tables.
select
count(*)
from items i
left join object_properties p on i.node_id = p.object_id
where p.name is null
nxdbmgr check does not find and purge these.
There do not appear to be any leftover data in the corresponding idata tables.
select
count(*)
from items i
left join object_properties p on i.node_id = p.object_id
where p.name is null