Examples of Ad-Hoc SQL Queries › List Userids for a Global ID

List Userids for a Global ID

This SQL query returns all the userids associated with a specific global ID for all the system images represented in the repository.

The IDMAP table contains the cross-reference information matching a global ID with each userid and system image combination that corresponds to that global ID. The USERINFO table is used to return the user name for the userid.

SELECT CIADB01.IDMAP.SYSID , CIADB01.IDMAP.USERID, NAME
FROM   CIADB01.IDMAP, CIADB01.USERINFO                 
WHERE GLOBALID = 'TESTU01' AND                         
      CIADB01.IDMAP.SYSID LIKE '%' AND                 
      CIADB01.IDMAP.SYSID = CIADB01.USERINFO.SYSID AND 
      CIADB01.IDMAP.USERID = CIADB01.USERINFO.USERID   
      ORDER BY SYSID, USERID;