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: 199, Answers: 1)
Asked on April 6, 2016 6:17 pm
8 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: 213)
Answered on April 6, 2016 6:21 pm