HP ALM Quality Center Dashboard Excel History Report

Whenever you are interested in ALM Quality Center audit history you have various choices of getting the information.

One way of extracting history information from the database is using the Excel reporting functionality of the HP ALM Quality Center Dashboard.

First create a new Excel Report in the Analysis View of the Dashboard (see documentation library of HP ALM on details how to create such a report).

In the tab Configuration you will find the Query Builder, which allows querying the underlying database server of ALM Quality Center using SQL.

This is a nice feature, if you have to apply more complex analysis. Especially analysis on history information will require accessing audit tables either through the HP ALM OTA API or through SQL or both.

Last Updated: 29 July 2015

Hits: 13841

Split and Transpose Strings

Splitting Strings is a trivial task. Using SQL unfortunately it is not so easy to do. Recently I had to split long concatenated strings from one field in an Oracle database.

Luckily I was not the only one facing this challenge and found helpful information on the internet.

Below an example that did the trick for me.

 -- Splitting test strings --
WITH qry AS (
Select 'a,b,c' As tf From Dual
Union Select 'd,e,f' As tf From Dual 
Union Select 'g,h' As tf From Dual 
Union Select 'i' As tf From Dual
) 
SELECT regexp_substr(tf, '[^\,]+', 1, rn) Transposed_Field 
FROM qry 
cross join 
(
Select rownum rn from ( 
select max(regexp_count(tf, ',')) + 1 mx from qry) connect by level <= mx 
) 
Where regexp_substr(tf, '[^\,]+', 1, rn) is not null
Order By Transposed_Field;

The resultset of above query will look like the following picture.

Last Updated: 01 January 2018

Hits: 16298

Connect to HP ALM via browser using REST API

Currently I am playing with the REST API of HP ALM and since some basics are always good before you start automating things, I first wanted to connect to ALM using a web browser.

Authentication

Open a browser and type in the following url, but replace the part {host} with the address to your HP ALM server.

https://{host}/qcbin/authentication-point/authenticate

This will display a simple login dialog, in which you provide your HP ALM user name and the corresponding password.

Last Updated: 03 January 2018

Hits: 29097