How to determine if a QC project has had any recent activity?
« Back
Tags:
Category:
Question ID: 104623
▲
3
▼
♥ 0

I am trying to archive some QC projects, but one of my users says it is still in use.
Is there an easy way to determine if the project has been used recently?

Marked as spam
Posted by (Questions: 23, Answers: 1)
Asked on October 1, 2012 12:36 pm
22 views
Answers (3)
▲
4
▼
✔
Private answer

For v11.52 SQL Server....

Select
P.PROJECT_NAME,
MAX(START_TIME) ''START_TIME''
From
td.SESSIONS_HISTORY H
JOIN td.PROJECTS P
ON P.PROJECT_NAME = H.PROJECT_NAME
WHERE PROJECT_TYPE = 'Standard'
AND USER_NAME NOT in ('_pc_system_','_system_user_')
Group By P.PROJECT_NAME
Order By START_TIME DESC

Marked as spam
Posted by (Questions: 0, Answers: 613)
Answered on February 12, 2014 7:53 pm
▲
3
▼
✔
Private answer

This is the SQL we use.

Select
PROJECT_NAME,
MAX(START_TIME) ''START_TIME''
From
td.SESSIONS_HISTORY
Group By PROJECT_NAME
Order By START_TIME DESC

Marked as spam
Posted by (Questions: 0, Answers: 613)
Answered on October 1, 2012 12:52 pm
▲
0
▼
Thank You, thats what I needed.
( at October 1, 2012 1:01 pm)
▲
0
▼
✔
Private answer

@SammyH
What are these user_name and what are their roles?
_pc_system
_system_user_

Marked as spam
Posted by (Questions: 1, Answers: 1)
Answered on July 22, 2015 9:50 pm
« Back
EyeOnTesting

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

Got it!
X
Scroll to Top