How to identify the actively used Project, last modified date? inactive projects using date time
| ♥ 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 |
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 Bakar_Ahmed (Questions: 0, Answers: 3) Answered on June 14, 2023 4:31 am
|