IBM Security Guardium

 View Only
  • 1.  Report creation Info

    Posted Fri May 14, 2021 01:13 AM
    Hi Everyone,

    I need to know about the below marked one (distinct) usage if we enable or disable during report creation.
    Please suggest.


    Thanks,
    Panendar Rao.C

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


  • 2.  RE: Report creation Info

    Posted Fri May 14, 2021 03:48 PM
    Distinct works in the same manner as it does for SQL statements. Based on your search fields if multiple records have the same values then it will only appear once in your results. Count is then optionally used to show the count of results matching those values. For example:

    ServerHostName   |   DB User Name   |   Port
    ServerHost1          |   DBUser1             |   1
    ServerHost3          |   DBUser5             |   2
    ServerHost1          |   DBUser1             |   1

    Will appear as:
    ServerHostName   |   DB User Name   |   Port   |   Count
    ServerHost1          |   DBUser1             |   1        |   2
    ServerHost3          |   DBUser5             |   2        |   1

    ------------------------------
    Chase Walkup
    ------------------------------