Listing Ideal Administrator ($$ID-ADM) users in DDOL or Ideal

Products

• Ideal
• Datacom

Issue/Introduction

A list of Ideal Administrator users can be produced via the following SQL query:

SELECT DISTINCT(SUBJ_OCC_NAME), STATUS, ENTITY_NAME, DATE_ADDED, OBJ_OCC_NAME, SUBJ_CON_DATE, OBJ_CON_DATE

FROM SYSADM.RELATIONSHIP

WHERE ENTITY_NAME = 'PER-ATZ-AUTH' AND OBJ_OCC_NAME LIKE '%ID-ADM%';

Is there any other way to produce that list on DDOL or Ideal?

Environment

Component : IDEAL

Resolution

There is no way to get the list in Ideal or DDOL natively.

However, you can use the PERSYS program, as it can be read in the Knowledge Base article titled "Listing Ideal users and systems with the PERSYS program sample".

It can easily used as a sample to write a program that extracts exactly what is required.

You can also run a DDUTILTY report to get the information.

Use this to get a list of users and the Ideal systems they have access to:

-DEF PATH,SYSATZ 
-DEF TRACE,PERSON.SYSTEM.PER-SYS-ACCESS 
-END 
-RPT START,PERSON,*(PROD,PRIV),SYSATZ 
-RPT INDEX 
-END 

Use this to get a list of users with ADMIN authority:

-DEF PATH,PERATZ 
-DEF TRACE,AUTHORIZATION.PERSON,PER-ATZ-AUTH 
-END 
-RPT START,AUTHORIZATION,$$ID-ADM(PROD,PRIV),PERATZ 
-RPT INDEX 
-END