How to remove disabled users from database

  • 7015641
  • 09-Sep-2014
  • 09-Sep-2014


Novell Data Synchronizer
Novell GroupWise Mobility Service


How to delete, remove, clear disabled users from Mobility datasync database


  1. See TID 7015282  - How to install dsapp on a Mobility server.
    Note: Once dsapp is installed, proceed with the steps below.

  2. Remove disabled users/groups from database:
    • Launch dsapp, select User Issues | Remove and reinitialize user options... | Remove disabled users & fix referenceCount
    • Enter y for Remove all disabled users/groups from target table
    • Enter n for Set referenceCount to 1 for all non-disabled users/groups

Additional Information

For manual steps:
  1. From a terminal window, enter the following command:
    psql -U datasync_user datasync -c "delete from targets where disabled != '0';"