Extract ALM user list for users active since a certain time

  • Questions
  • Extract ALM user list for users active since a certain time
Question ID: 108534
0
0

Is there a way to extract the email of users that have been active over a selected time period? ALM doesn’t have a mass email button and users are never logged in at the same times. We have over 2000 user names listed.

Marked as spam
Posted by (Questions: 91, Answers: 0)
Asked on July 26, 2018 3:09 pm
2 views
Answers (1)
0
Private answer

You may be able to have your DBA do something like this using the ''Sessions_History'' table in site admin (you can change the time period to whatever time that you would like to see that they have been active from):

SELECT Distinct td.USERS.USER_NAME, td.USERS.USER_ID, td.USERS.EMAIL
FROM td.SESSIONS_HISTORY INNER JOIN
td.USERS ON td.SESSIONS_HISTORY.USER_NAME = td.USERS.USER_NAME
WHERE (td.SESSIONS_HISTORY.END_TIME > '2017 -12-22 15:20:41.297')

Marked as spam
Posted by (Questions: 0, Answers: 340)
Answered on July 26, 2018 3:11 pm