4 Replies Latest reply on Dec 4, 2019 10:31 AM by David K Hill

    SQL query to delete users from CTM:People

      Share This:

      Hi Experts,


      How to delete users in CTM:People from directly using SQL query?

      In which tables information about these users will be stored?


      I know it’s not good to delete records directly from backend. But I am development environment, and we have some test cases (code of which I do not have access to) which are creating user and are not deleting at the end.

      So, I am trying to find a easier way to delete these unnecessary user records.


      Environment details,

      BMC Remedy ITSM Suite Preconfigured Stack8.1.00

      Oracle 11g R2PS2 DB


      Thanks in advance.