User Login/Access Reporting

Hi ​@frank palacios, 

To report which users are logging into Eightfold by permission group, specifically for recruiters, you can use the following SQL query:

sql

SELECT distinct user_id, event, permissions_json.roles, has_recruiter_access

FROM [CUSTOMER]_user_analytics as A

INNER JOIN (SELECT   * FROM [CUSTOMER]_user_login WHERE has_recruiter_access = TRUE) as B

ON B.email = A.user_id

WHERE user_id != ''


This query will provide you with a list of users who have recruiter access and their associated events. Be sure to adjust the timestamps and any other filters as needed to fit your reporting requirements.