How-To - ArcFM - Delete All User Stored Displays for Multiple Users

Version 1

    Solution

     

    User stored displays can be deleted in ArcMap, but this requires logging in as each user to delete them. When it is necessary to delete them for multiple users, it is more efficient to use a SQL tool. This involves deleting the stored displays from the MM_STORED_DISPLAYS table, and deleting the rows from MM_PACKAGES that contain the items displayed in the Stored Displays tab of Stored Items in ArcMap. Follow the steps below to delete them.

     

    1.  In a SQL tool for the Oracle or Microsoft SQL Server database, connect to the database as the owner of the ArcFM system tables. This is usually SDE.

     

    2.  Back up the MM_STORED_DISPLAYS and MM_PACKAGES table for safety.

     

    3.  Delete the user stored displays from MM_STORED_DISPLAYS.

    Use this query to review the user stored displays for multiple users. In this example the user stored displays for USER1, 2 and 3 will be deleted.

    select * from SDE.MM_STORED_DISPLAYS where USERNAME in ('USER1', 'USER2', 'USER3');

    Delete them with this statement:

    delete from SDE.MM_STORED_DISPLAYS where USERNAME in ('USER1', 'USER2', 'USER3');

     

    4.  Delete the rows from MM_PACKAGES that contain the items displayed in the Stored Displays tab of Stored Items in ArcMap.

    Use this query to review the rows to delete:

    select * from SDE.MM_PACKAGES where NAME = 'User Stored Displays' and USERNAME in ('USER1', 'USER2', 'USER3');

    Delete them with this statement:

    delete from SDE.MM_PACKAGES where NAME = 'User Stored Displays' and USERNAME in ('USER1', 'USER2', 'USER3');

     

    5. Optionally, delete the rows from MM_PACKAGES that contain the items listed in the most recently used list at the top of the Stored Displays tab.

    Note: This will remove all recently used stored displays including any system stored displays. It is okay to leave these in place. If a user selects a stored display that has been deleted, they will just get a warning that asks if they want to remove the stored display from the list.

     

    Use this query to review the rows to delete:

    select * from SDE.MM_PACKAGES where NAME = 'User MRU Stored Displays' and USERNAME in ('USER1', 'USER2', 'USER3');

    Delete them with this statement:

    delete from SDE.MM_PACKAGES where NAME = 'User MRU Stored Displays' and USERNAME in ('USER1', 'USER2', 'USER3');