Commodore
Commodore
289 views

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.

0 Likes
1 Reply
Fleet Admiral
Fleet Admiral

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'
Jan Czajkowski

[Please do not contact me off line for receiving support. Use the forum!]
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.