add

About Me

My photo
Oracle Apps - Techno Functional consultant

Monday, September 19

Number of users logged into Oracle E-Business Suite

SELECT
TO_CHAR(START_TIME,'DD-MON-YYYY') Login_Time,
COUNT(*) cnt
FROM fnd_logins
WHERE
START_TIME >
( SELECT TO_DATE('25-AUG-2010 00:00:00','DD-MON-YYYY HH24:MI:SS')
FROM dual
)
AND login_type IS NOT NULL
AND END_TIME IS NULL
GROUP BY TO_CHAR(START_TIME,'DD-MON-YYYY');

No comments: