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.  Guardium 11.2 Entities

    Posted Fri September 04, 2020 09:54 AM
    Hello.
    When creating a query in Guardium 11.2 we need to choose Main Entity but after choosing it and getting further we should choose Entity & Attributes and there we can choose Entity that is different from Main entity. How does it work? Does it mean that if we choose Session entity and then choose Full SQL in Entity & Attributes it will show us Full SQL even if Main Entity doesn't have it inside and we can mix attributes from different entities no matter what entity was chosen as Main? What is Main entity used for then?
    Or Main entity works as some sort of limiter that limits attributes that are available for showing in report and attributes from other entitiies that don't exist in entitty that is set as Main will not be shown in report (even if they are chosen in Query builder)?


    ------------------------------
    Igor Volkov
    ------------------------------


  • 2.  RE: Guardium 11.2 Entities

    Posted Wed September 09, 2020 04:06 AM

    Main entity defines relation between tables in your query

    If you selected Session as a main entity the relation to full SQL is 1:N so in the Full SQL column you will have number of SQL visible in this session.

    Read more for example from my blog:

    https://guardiumnotes.wordpress.com/2017/10/06/guardium-reports-platform-understanding-1/



    ------------------------------
    Zbigniew (Zibi) Szmigiero
    IBM
    Międzyrzecz
    ------------------------------

    Original Message


Related Content