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

Products

• Ideal
• Datacom

Issue/Introduction

A list of Ideal Adminitrator 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

Release : 15.0

Component : CA 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 on "CA Ideal users/system access levels via PERSYS sample" article.

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

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

Use this to get list of users and the CA 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