Problem statement:

ARTIFACTORY: How to get the list of users who added an SSH key under the user profile page

AuthorFullName__c
Janardhana JL
articleNumber
000006109
ft:sourceType
Salesforce
FirstPublishedDate
2024-05-28T06:14:49Z
lastModifiedDate
2025-02-22
VersionNumber
4

Currently, there is no direct approach to retrieve the list of users who added SSH keys.
Example user profile page with SSH key added:

User-added image


The user names can be retrieved from the "access_users_custom_data" table with the following query.

SELECT username FROM access_users WHERE user_id IN (SELECT distinct user_id FROM access_users_custom_data WHERE prop_key like '%sshPublicKey%' and prop_value is not null);