IBM Security Guardium

  • 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

    IBM Select
    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
    ------------------------------