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'));
Try this and see if it gives you the required data
SELECT user_name,To_Char(login_date,'Month'),db_engine_type, Count(*)
WHERE login_date > '01-Jun-2013'
GROUP BY user_name,db_engine_type,To_Char(login_date,'Month');