How to identify Inactive projects in RQM
Hi,
Has anybody found a method to find the inactive projects in RQM .
An inactive project can be classified based on
1. No of Test Assets (TC, TP, TS etc)
2. Last modified dates of these Assets
3. Last Test Executions (TCER, TSER)
Since we have 350 projects any manual effort to get these data is time consuming.
2 answers
You could write a script or custom code using the RQM Reportable API.
For example, using the Project Feed Service (https://jazz.net/wiki/bin/view/Main/RqmApi#Project_Feed_Service), GET all the project areas, and for each project GET all resources modified (https://jazz.net/wiki/bin/view/Main/RqmApi#modifiedSince) since a certain date. If none, the project is inactive.
See https://jazz.net/wiki/bin/view/Main/RqmApi#Common_Usage_Scenarios as a starting point.
For example, using the Project Feed Service (https://jazz.net/wiki/bin/view/Main/RqmApi#Project_Feed_Service), GET all the project areas, and for each project GET all resources modified (https://jazz.net/wiki/bin/view/Main/RqmApi#modifiedSince) since a certain date. If none, the project is inactive.
See https://jazz.net/wiki/bin/view/Main/RqmApi#Common_Usage_Scenarios as a starting point.