Run Orphan Searches

In the Metadata Manager, orphan searches allow you to search for items that do not have immediate parent, children, or mapping relationships. You can use orphan searches to find items that do not have owners, items that do not own any immediate children, or belong to a datamap. These items may need to be reviewed and cleaned up.

Search for Items not Used Anywhere

To search for items that are not used anywhere:

  1. From any Metadata Manager window, click the double arrow next to the Search button to access the Search dialog box.

  2. In the Search dialog box, click the Orphan tab.

  3. Click the Search for drop down and select a type.

  4. Click that drop down and select have no parents, no children, and no mapping.

  5. Click the Search button in the lower left corner of the Search dialog box.
    In the Search Results window, you see the items based on the criteria you selected.

  6. Click the Path name for any item you wish to view in the Item Detail window.

  7. Click the Types bottom tab to return to the Types window.

Search for Items without Parents or Mapping

To search for items without parents or mapping:

  1. From any Metadata Manager window, click the double arrow next to the Search button to access the Search dialog box.

  2. In the Search dialog box, click the Orphan tab.

  3. Click the Search for drop down and select a type.

  4. Click that drop down and select have no parents, or have no parents and no mapping.

  5. Click the Search button in the lower left corner of the Search dialog box.
    In the Search Results window, you see the items based on the criteria you selected.

  6. Click the Path name for any item you wish to view in the Item Detail window.

  7. Click the Types bottom tab to return to the Types window.

Search for Items without Children or Mapping

To search for items without children or mapping:

  1. From any Metadata Manager window, click the double arrow next to the Search button to access the Search dialog box.

  2. In the Search dialog box, click the Orphan tab.

  3. Click the Search for drop down and select a type.

  4. Click that drop down and select have no children, or have no children and no mapping.

  5. Click the Search button in the lower left corner of the Search dialog box.
    In the Search Results window, you see the items based on the criteria you selected.

  6. Click the Path name for any item you wish to view in the Item Detail window.

  7. Click the Types bottom tab to return to the Types window.