How to identify the actively used Project, last modified date? inactive projects using date time
Question ID: 110566
0
0

We are in process of identifying actively used project for a time period so that to remove old data or unused projects which are not in use for more than 5+ years

Please share us some documents and good practices on

Marked as spam
Posted by (Questions: 3, Answers: 0)
Asked on June 14, 2023 4:30 am
34 views
Answers (1)
1
Private answer

You or your DBA can access the qcsiteadmin_db, and query the PROJECTS table to get the LAST_TOUCH_TIME for your projects. The LAST_TOUCH_TIME is the date and time any entity was created or edited in ALM. If you are using SQL Server, I have entered a query below that you can use to get this data. You will need to edit the query to work in your environment. Make sure the date and time format matches what is in the LAST_TOUCH_TIME column.

SELECT [PROJECT_ID]

      ,[PROJECT_NAME]

      ,[DOMAIN_ID]

      ,[DOMAIN_NAME]

      ,[PHYSICAL_DIRECTORY]

      ,[DESCRIPTION]

      ,[LAST_TOUCH_TIME]

      ,[PROJECT_TYPE]

FROM [qcsiteadmin_db].[td].[PROJECTS]

WHERE LAST_TOUCH_TIME > '2020-03-03 17:04:22.227'

This Query helps to get the data about projects and when they are lastly touched.

Marked as spam
Posted by (Questions: 0, Answers: 3)
Answered on June 14, 2023 4:31 am
EyeOnTesting

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

X
Scroll to Top