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.

      Sandeep