We help IT Professionals succeed at work.

Count of Connects by User in the Last Week

Cha1tu
Cha1tu asked
on
Medium Priority
462 Views
Last Modified: 2013-12-18
When i query this SQL Statement

SQL> SELECT das.username,
  2         COUNT(*) logonCount
  3    FROM sys.dba_audit_session das
  4   WHERE das.timeStamp > SYSDATE-7
  5     AND das.returnCode = 0
  6   GROUP BY das.username;


USERNAME   LOGCOUNT
TEST              11
DBA               16
DECV               8
USER1             2
TEST                2

would like to see where the connects are coming from. ?
Comment
Watch Question

Commented:
Maybe das.USERHOST or das.TERMINAL has the information you want?

Author

Commented:
WHEN I EDIT THIS


SELECT das.username,
       das.USERHOST,
       das.TERMINAL,
           COUNT(*) logonCount
         FROM sys.dba_audit_session das
        WHERE das.timeStamp > SYSDATE-7
       AND das.returnCode = 0
       GROUP BY das.username;


please the results in the attached file New-Microsoft-Word-Document.doc
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.