When you need to conduct project maintenance in ALM admin. You should have all items Checked In. As ALM / Project Admin, what is the easiset way to find all artifacts (by all users) that are Checked Out and How do you Check In the items in mass
Answer by TLStockton · Apr 24, 2013 at 12:41 AM
If you are using SQL Server, try this:
SELECT * from ( SELECT 'REQ' AS TYPE, RQ_REQ_ID as ID, RQ_REQ_NAME as NAME, RQ_vC_CHECKOUT_USER_NAME as QC_USER, RQ_VC_STATUS as VC_STATUS FROM td.REQ UNION SELECT 'TEST' as TYPE, TS_TEST_Id as ID, TS_NAME as NAME, TS_vC_USER_NAME as QC_USER,TS_VC_STATUS as VC_STATUS from td.TEST UNION SELECT 'BUS_MODEL' as TYPE, BPMM_Id as ID, BPMM_NAME as NAME, BPMM_VC_CHECKOUT_USER_NAME as QC_USER,BPMM_VC_STATUS as VC_STATUS from td.BPM_MODELS UNION SELECT 'TEST_RESOURCES' as TYPE, RSC_ID as ID, RSC_NAME as NAME, RSC_vC_CHECKOUT_USER_NAME as QC_USER, RSC_VC_STATUS as VC_STATUS from td.RESOURCES UNION SELECT 'COMPONENT' AS TYPE, CO_ID AS ID, CO_NAME AS NAME, CO_VC_CHECKOUT_USER_NAME as QC_USER, CO_VC_STATUS as VC_STATUS FROM TD.COMPONENT ) A WHERE VC_STATUS = 'Checked_Out' ORDER BY TYPE, NAME
Answer by tclasp · Apr 23, 2013 at 09:36 PM
There is no single OTB feature that will do this for you. But there are several items you can look at.
Each module (Requirements, Test Plan, etc) supports setting a Filter so that you can view all the checked-out items.
Alternately, if you have access to read the project database, you can look at all the tables with names starting with VC_. Those are the tables that track checked out items.
And, there is no mass-check-in tool.
This sounds like an excellent idea for an enhancement request. You should file one with HP to get them to build such a tool.
Answer by fred · Apr 24, 2013 at 05:23 PM
Thank you everyone for the reply. I have also found out that Version 10.x has the capability to Filter by Checked Out Documents. Version 11.x has removed the fields for filtering. Not a smart move. The only way I found to see them is via SQL in 11.x.
Test Instances by Path 2 Answers