Query for ALM 11.52 to find out what users logged into a project (s) in the past 30 days
Why is this so hard - does someone have a Query for ALM 11.52 to find out what users logged into a project (s) in the past 30 days?
And please don't send me here (http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1428113 )- this page is no longer accessable.
The query will depend on which DB you are using, SiteAdmin DB name, date format and project name. But here is a query that works in my environment:
SELECT DISTINCT USER_NAME FROM QCSITEADMIN_DB.DBO.SESSIONS_HISTORY WHERE START_TIME > '2018-10-01' AND PROJECT_NAME = 'XYZ'
[Please do not contact me off line for receiving support. Use the forum!]