1 Reply Latest reply: Nov 21, 2013 1:38 PM by CSX4life RSS

    Need help with SQL query on usessaud table

    CSX4life

      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

      WHERE LOGIN_DATE

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

       

      Thanks,

      Jim