There isn't an out of the box report that gives you just the full user details, but you can use the SQL below to create a Cognos report with a custom SQL query to give you what you should need.
SELECT A.actorid "Actor ID",
AI.NAME "User Name",
AI.EMAIL "User Email",
UI.FIRSTNAME "User First Name",
UI.MIDDLENAME "User Middle Name",
UI.LASTNAME "User Last Name",
OP_ACTOR_MGR.GET_DISPLAY_NAME(AI.NAME ,null) "User Display Name",
AI.DESCRIPTION "User Description",
DECODE(A.ISENABLED, 1, 'Yes', 'No') "User Is Enabled?",
DECODE(U.LOCK_TYPE_ID , null, 'No', 'Yes') "User Is Locked?",
(select P.NAME
from ACTORS_OBJ_PROFS AP, OBJECT_PROFILES P
WHERE A.ACTORID = AP.ACTOR_ID
AND AP.OBJECT_PROFILE_ID = P.OBJECT_PROFILE_ID
and flag_is_not_preferred=0) "User Current Profile",
(select LISTAGG(p.name, chr(10))
from ACTORS_OBJ_PROFS AP, OBJECT_PROFILES P
WHERE A.ACTORID = AP.ACTOR_ID
AND AP.OBJECT_PROFILE_ID = P.OBJECT_PROFILE_ID ) "User Profiles List",
(SELECT NAME FROM I18N_LOCALES WHERE I18N_LOCALE_ID = AI.I18N_LOCALE_ID) "User Locale",
(SELECT CAST(MAX(AAT.CREATED_ON) AS DATE)
FROM ACTOR_AUDIT_TRAIL AAT
WHERE AAT.ACTOR_ID = A.ACTORID
AND AAT.AUDIT_TRAIL_TYPE_ID = 4
AND AAT.FLAG_IS_SUCCESSFUL=1
) "User Last Login Date",
U.PASSWORD "User Password",
U.EXPIRATION_PERIOD "User PWD Expiration Period"
FROM ACTORINFO AI,
USERINFO UI,
ACTORS A,
USERS U
WHERE A.ACTORID = AI.ACTORID
AND A.ACTORID=UI.ACTORID
AND A.ACTORID=U.ACTORID
AND A.TYPE=1
------------------------------
Ian Sankey
------------------------------
Original Message:
Sent: Tue September 06, 2022 08:33 AM
From: Raman Minhas
Subject: OpenPages Users Data Export
Hi,
is there way to export all User Data from Openpages . We need the Data to ascertain which users already been created in system and to avoid creating duplicates while importing new Users.
------------------------------
Raman Minhas
------------------------------
#Governance,RiskandCompliance