How to clean up unused item tree entries
You can clean up un-used item tree entries from SysManager > Utilities > Data Maintenance via the Find Unused Item Tree Entries utility.
How to use the find unused item tree entries utility:
Warning: Make a complete backup of your SiriusSQL database.
1. Run SysManager > Utilities > Data Maintenance > Find Unused Item
Tree Entries.
2. Select a cut-off date.
3. Enter any exceptions using the three text boxes; click OK.
4. Make sure to review the entire list of item tree nodes (including DCIs)
to be removed; click Continue
5. Click Yes to confirm the removal; click No to cancel the removal if you
are not 100% sure.
Warning:
• It is very important to have a backup of the SiriusSQL database, because the only way to “undo” the unused item tree entries removal is to restore the data. If possible, please run this utility on your test or training database first
• Salespoints instantly reflect changes made by the unused item tree entries removal utility; therefore, it is best to run this utility during non-operational hours to make sure the removal is done properly and Sales gets the correct update of the item tree when back in business.