Determining when a user was added
Question ID: 106744
0
0

Is there a way to determine when a user was added to the ALM (DATE)?

Marked as spam
Posted by (Questions: 204, Answers: 2)
Asked on April 6, 2016 6:17 pm
58 views
Answers (1)
1
Private answer

![alt text][1]You can query the SiteAdmin database via the Excel Report Query Bulider as shown in the attached file.
There you would enter the query I suggested before:
select [User],max(START_TIME) as ''Login_TS''
from
(
select USER_NAME as ''User'' from [qcsiteadmin_db].[td].USERS
) AllUsers
left outer JOIN [qcsiteadmin_db].[td].SESSIONS_HISTORY ON [User]=SESSIONS_HISTORY.USER_NAME
group by [User]

[1]: /storage/temp/432-excelreportquerybuilder.png

Marked as spam
Posted by (Questions: 1, Answers: 216)
Answered on April 6, 2016 6:21 pm
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top