2 Replies Latest reply on Oct 18, 2019 10:40 AM by Adriano Gomes

    Want to extract a list of inactive users in control m environment (preferably  users which are inactive from last three months)

    Rahul Panigrahi
      Share This:

      Want to extract a list of inactive users in control m environment (preferably  users which are inactive from last three months)

       

      Using PostgreSQL and our audit retention days is 7.

       

      Query using:

      select username from generalauthorizations

      except

      select username from audit_activities where timestamp < '2019-09-17 00:05:00' and operation='LOGIN USER';

       

      please advise

       

      Can we get list of inactive users even my audit retention is 7

      Any changes to query?