AxoSoft OnTime – Metrics – Defects by Severity

Thursday, July 18th, 2013

I have recently been introduced to a new tool, Axosoft’s OnTime. For what it is, it works well as an Agile project management tool, complte with defect and incident tracking. From a quality assurance perspective, it’s nice to have flexibility of workflow management, custome fields and such. What I have found a bit lacking, however, is consistent metrics. I’m prone to create my own metrics reporting, so I have a tendency of querying databases directly.

In OnTime, the data structure is fairly straightforward. However, our organizational structure within the tool’s concepts of Releases and Projects is hierarchal in nature and makes my queries a tad more complex.

HP ALM – Determining when a Test Case Instance is added to a Test Set

Thursday, August 23rd, 2012

As mentioned in a previous post, my team has been attempting to generate reporting metrics directly out of the ALM database. One of the issues we were running into was determining when a Test Case Instance (TESTCYCL) has been added to a Test Set (CYCLE). There were many queries put together and tables examined and […]

HP ALM Database metrics

Tuesday, August 14th, 2012

The past week has seen me and my team attempting to create several SQL Queries to pull specific information out of our HP ALM Project databases. Basically, we are looking to pull test case execution and status updates per day and report on our local Confluence installation. The TESTCYCL table stores data pertaining to each […]