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
BETWEEN trunc(TO_DATE('2013-11-21','YYYY-MM-DD')) AND trunc(TO_DATE('2013-06-01','YYYY-MM-DD'));