How to remove disabled users from database

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
  

For manual steps:

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