Extract ALM user list for users active since a certain time
Question ID:
108534
| ♥ 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 Answers (1)
|
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 Marked as spam
 Posted by josh-yates (Questions: 0, Answers: 364) Answered on July 26, 2018 3:11 pm
|