IBM Verify

IBM Verify

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
Back to discussions
Expand all | Collapse all

How to find Supervisior details using SQL query .

  • 1.  How to find Supervisior details using SQL query .

    Posted Tue May 12, 2020 02:04 AM
    In IBM IGI , The campaigns database table "ATTESTATION" does not capture supervisor details. The column is present but has no records in it .


    To get the details of Supervisor information for campaign, we need to use this below tables from IGACORE schema .

    > PERSON
    > ATTESTATION
    > SUPERVISOR

    e.g

    SELECT * from IGACORE.PERSON where id in (select distinct this_.PERSON as y0_ from IGACORE.SUPERVISOR this_ inner join IGACORE.ATTESTATION attestatio1_ on this_.ATTESTATION=attestatio1_.ID where (1=1) and attestatio1_.ID=155)

    NOTE - We can find ATTESTATION_ID from IGACORE.ATTESTATION table.


    ------------------------------
    Ranvijay Singh , IAM SME
    IBM , Pune
    ------------------------------