Finding all checked out items in ALM

  • Questions
  • Finding all checked out items in ALM
Question ID: 104980
6
0

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

Marked as spam
Posted by (Questions: 1, Answers: 1)
Asked on April 23, 2013 6:26 pm
128 views
Answers (5)
4
Private answer

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.

Marked as spam
Posted by (Questions: 1, Answers: 101)
Answered on April 23, 2013 9:36 pm
4
Private answer

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
) A
WHERE VC_STATUS = 'Checked_Out'
ORDER BY TYPE, NAME

![alt text][1]

[1]: /storage/temp/91-eot_checked_out.jpg

Marked as spam
Posted by (Questions: 23, Answers: 1)
Answered on April 24, 2013 12:41 am
Counting items in version control tables.... SELECT 'COMPONENT' AS NAME, COUNT(*) FROM TD.VC_COMPONENT UNION SELECT 'REQUIREMENT' AS NAME,COUNT(*) FROM TD.VC_REQ UNION SELECT 'TEST_RESOURCES' AS NAME, COUNT(*) FROM TD.VC_RESOURCES UNION SELECT 'TEST' AS NAME, COUNT(*) FROM TD.VC_TEST UNION SELECT 'BUS_MODEL' AS NAME, COUNT(*) FROM TD.VC_BPM_MODELS
( at October 28, 2013 6:58 pm)
3
Private answer

See the ALM Users Guide * Chapter 6 * Version Control * How to Filter by Version Control Fields * Page 128.

There you can see which field names to use in the filter.

Marked as spam
Posted by (Questions: 0, Answers: 613)
Answered on April 24, 2013 12:26 am
2
Private answer

We do run this MS SQL Query to see all the tests that are checked out.
SELECT * FROM TEST where TS_VC_STATUS = 'Checked_Out'

Marked as spam
Posted by (Questions: 70, Answers: 111)
Answered on April 24, 2013 12:29 am
0
Private answer

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.

Marked as spam
Posted by (Questions: 1, Answers: 1)
Answered on April 24, 2013 5:23 pm