1 Reply Latest reply on Nov 21, 2013 7:48 PM by Sachin Gupta

    Need help with SQL query on usessaud table


      I need SQL assistance to determine what unique users have logged on to P6 by both P6 web and P6 PRO in the passed 3 months, with a count of the # times each person logged in BY month.  It looks like there should be a way to do this within the application but alas, no functionality to do so.  Does anyone else on the forum has any SQL to help me get started?


      Example I canno tget to work - returns no values:


      select distinct user_name

      from usessaud


      BETWEEN trunc(TO_DATE('2013-11-21','YYYY-MM-DD')) AND trunc(TO_DATE('2013-06-01','YYYY-MM-DD'));