Do you have a query that will tell you who is connected, their start time, and last action time for a given ALM project?

Tags:

Question ID: 106458

I know that you can use the Site Connections tab to perform the following:
Monitor the users currently connected to an ALM server. For each user, you can view the
domain and project being used, the user’s machine name, the time the user first logged in to the
project, and the time the most recent action was performed. You can also view the client type
connection to the ALM server.
However, I am looking for a query that someone can run OUTSIDE of the ALM interface. I don’t want to give non-admins access to the Site Administration tool.

Marked as spam

Posted by godawgs (Questions: 204, Answers: 2)

Asked on October 23, 2015 6:46 pm

64 views

Answers (1)

▲

▼

✔

Private answer

Try the following SQL query on the qcsiteadmin_db database on an SQL tool like SQL Server Manager:

Select
PS_ID as 'Session ID',
LS_USER_NAME as 'User Name',
LS_CLIENT_HOST as 'Client System Name',
LS_CLIENT_TYPE as 'Connection Type',
LS_LOGIN_TIME as 'Login Date/Time',
LS_LAST_ACTION_TIME as 'Last Action Date/Time'
FROM td.PROJECT_SESSIONS
JOIN td.LOGIN_SESSIONS on LS_ID=PS_LS_ID
WHERE
PS_DOMAIN_NAME = '' AND
PS_PROJECT_NAME = ''

Obviously, you need to put in your ALM Domain Name and ALM Project Name.
When I did that for the ALM_Demo project and Default domain, it looked like this:
PS_ID as 'Session ID',
LS_USER_NAME as 'User Name',
LS_CLIENT_HOST as 'Client System Name',
LS_CLIENT_TYPE as 'Connection Type',
LS_LOGIN_TIME as 'Login Date/Time',
LS_LAST_ACTION_TIME as 'Last Action Date/Time'
FROM td.PROJECT_SESSIONS
JOIN td.LOGIN_SESSIONS on LS_ID=PS_LS_ID
WHERE
PS_DOMAIN_NAME = 'Default' AND
PS_PROJECT_NAME = 'ALM_DEMO'

Here are the results I obtained:![alt text][1]

[1]: /storage/temp/361-connection-results.png

Marked as spam

Posted by David Hall (Questions: 1, Answers: 216)

Answered on October 23, 2015 6:54 pm

« Back

Please log in to participate..

Forgot your password?