-
1. Re: Find currently logged in users
Rich Johnson Apr 22, 2016 5:14 AM (in response to omsachdev83)1 of 1 people found this helpfulNo.. You would need to look in the admin console or run a repository query.
-
2. Re: Find currently logged in users
omsachdev83 May 4, 2016 2:11 PM (in response to Rich Johnson)Could you please provide more information on that? I didnt see all the logged in users under repository-->connections.
Also, please share the query if possible.
-
3. Re: Find currently logged in users
Nirmal Govindprasad May 5, 2016 2:42 AM (in response to omsachdev83)1 of 1 people found this helpfulHi Om,
There is debugging tool provided by Informatica called FormatUserConnections to check the repository connections.
Click to download it and run the tool with given options.
Hope this helps.
Thanks.
-
4. Re: Find currently logged in users
Rich Johnson May 5, 2016 3:13 AM (in response to omsachdev83)All users logged into the repository should definitely show up under Repository -> Connections and Locks, and you can get the same information from the opb_client_conn table (client_type < 10 omits the integration service connections to the repository):
SELECT ug.name AS username, ug.name_space, cc.login_time,cc.app_name1 AS client_tool,cc.cnx_id,
cc.process_id AS PID,cc.host_name,cc.host_addr
FROM pm_repository.opb_client_conn cc,
pm_repository.opb_user_group ug
WHERE cc.login_id=ug.id
AND cc.client_type < 10
ORDER BY ug.name, cc.login_time desc
-
5. Re: Find currently logged in users
omsachdev83 May 23, 2016 2:26 PM (in response to Rich Johnson)Thanks, will try again.