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.  Using Group By in Query Report Builder

    Posted Wed July 12, 2023 03:47 AM

    Hello Seniors,

    Is there any way in Query Report Builder OR anywhere , where we can put Group By condition , for example, Total Full SQL Group by Source Program, OR DB User. OR any alternative for this. thanks much!



    ------------------------------
    Sincerely,
    Akash Parmar
    ------------------------------


  • 2.  RE: Using Group By in Query Report Builder

    Posted Tue July 25, 2023 08:01 AM

    Could adding distinct and count column help you to solve this? 



    ------------------------------
    TAL DANIEL
    Guardium developer
    IBM Security
    Israel
    ------------------------------



  • 3.  RE: Using Group By in Query Report Builder

    Posted Tue July 25, 2023 08:37 AM

    Hi Tal Daniel,

    Thank you for the response. to some extent , this count/district is helping. But, not actually it is doing task of what Group By can do it. Any ways, I got the alternative , Now, I am using Quick Search to get the desired output. thanks!



    ------------------------------
    Akash Parmar
    ------------------------------