Finding Test Instance Name on HP ALM 12.53 database

  • Questions
  • Finding Test Instance Name on HP ALM 12.53 database
Question ID: 107682

I am trying to develop a business view that includes (among other things) the test instance name For the life of me, I can’t find where test instance name is kept on the database. I need this (as opposed to just going with the test name… e.g. BrentTest) so that the report differentiates between the same test script being used multiple times in the same test set (e.g. BrentTest[1], BrentTest[2], etc.) Thoughts?

Thanks, Brent

Marked as spam
Posted by (Questions: 9, Answers: 2)
Asked on June 16, 2017 1:58 pm
Answers (1)
Private answer


In the database, under your project tables, look to .d.TESTCYCL table. This will have the test instance fields.

See DB reference here: [HPE Database Reference][1]

In it is TC_TEST_ID which is same as the TS_TEST_ID (the actual test ID seen in test plan).

That won't get you the name though of the actual test with the 1, 2, 3.

Business view though for Test Instance already exists. It is named Test Instances. This includes the Test Instance Unique ID and the test_instance_name among other fields.

The test_instance_name is going to be the name like Brent[1] or Brent[2].

See below for the business view as defined in project customization, and then for actual selection from Excel and an actual result.

These show you the values you would want to pull to use in a custom view if that is how you need to move forward.

![alt text][2]

![alt text][3]

![alt text][4]

[2]: /storage/temp/626-bviews-test-instances.png
[3]: /storage/temp/627-bvs-test-instances-001.png
[4]: /storage/temp/628-excel-view-test-instances.png

Marked as spam
Posted by (Questions: 1, Answers: 116)
Answered on June 16, 2017 7:13 pm
Thank you. Brent
( at June 20, 2017 6:54 pm)