Count of Connects by User in the Last Week

Posted on 2011-04-28
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;

TEST              11
DBA               16
DECV               8
USER1             2
TEST                2

would like to see where the connects are coming from. ?
Question by:Cha1tu
    LVL 5

    Expert Comment

    Maybe das.USERHOST or das.TERMINAL has the information you want?
    LVL 2

    Author Comment


    SELECT das.username,
               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
    LVL 5

    Accepted Solution

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now