Details
-
Suggestion
-
Resolution: Unresolved
-
None
-
None
-
7
-
Description
Users of Insight often encounter issues with having to many duplicate objects in their object schemas. There needs to be a way to find duplicate objects with IQL. I am suggesting an improvement for SQL scripts to be able to find duplicates.
The workaround that currently exists is the following
What you can do at the moment, using IQL:
a. Visually locate a duplicated Object.
b. identify the Duplicate from the Original (the object id of the original will be lower than the duplicate, and reflected in the numeric part of the object Key, e.g. KEY-123 = original while KEY-234 is a duplicate as objectId: 123<234 )
c. If there are a few duplicates, locate the oldest one - and note the Created date & Time
d. Use the Insight object search to filter on your All your Schema Objects Created from the Duplicate Create date onward, e.g. IQL: Created >= 29/Jun/2020 05:36:00
e. Note that some objects may have been created legitimately and ARE NOT Duplicates, hence you should carefully revise the filtered objects, before deleting any.
f. we strongly recommend to create a Jira/DB Backup before you start deleting any object - to allow a valid restore point. As deleting Objects is irreversible unless you restore a backup.
However working with very high volumes of objects makes this workaround not sufficient.
Kind regards
Thomas