Monday, September 19, 2011

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 1=1
  AND 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:

Post a Comment

Best Blogger TipsGet Flower Effect