IBM Guardium

IBM Guardium

Join this online user group to communicate across Security product users and IBM experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  SQL Query and Session Duration

    Posted Thu June 10, 2021 02:44 AM
    Hi Everyone,

    Can anyone let me know what parameter add in the report to find out the SQL Query execution duration and session duration?

    Thanks,
    Panendar Rao.C

    ------------------------------
    PHANENDRA RAO CHAVANA
    ------------------------------


  • 2.  RE: SQL Query and Session Duration

    Posted Fri June 11, 2021 12:26 AM
    HI all,

    Can anyone help with below request please?

    Thanks,
    Panendar Rao.C

    ------------------------------
    PHANENDRA RAO CHAVANA
    ------------------------------



  • 3.  RE: SQL Query and Session Duration

    Posted Fri June 11, 2021 05:21 AM
    Entity Session column Duration. 
    SQL Query execution duration I didn't find

    ------------------------------
    Miroslaw Heimrath
    ------------------------------



  • 4.  RE: SQL Query and Session Duration

    Posted Thu June 17, 2021 10:46 PM
    Hi Panendar,

    For SQL Query execution duration, you can use "response time" field in Full SQL entity.
    session duration, there is a field "Duration" in session entity for it.  Please refer to https://www.ibm.com/docs/en/guardium/11.1?topic=domains-access-domain.

    ------------------------------
    Jonathan LU
    Security Support Engineer
    IBM
    ------------------------------