Currently within our workflow customization we have a need to execute a query against the DB to determine if a linked defect exists when a user sets the status of a defect to duplicate. We discovered that only if someone was in the admin group that this query executed. After doing research we did fi...

I have tried and can get the data using a Business View Graph for Test Configurations, with X-axis as Test Name, Y-axis as count Distinct Test Status and group by Test Config Exec Status. I don't see how I can specify the data to be only for the last 2 days. Please advice.

Back In QC 9.2 we have OTA OBJECT MODEL in the OTA HELP file, from this object we will be able to clearly see the relationships between each object in a diagramatic representation. Is there any such OTA OBJECT Model for latest version of ALM , If not how are we actually figuring out the flow of all ...

Is there a way to reference FULL_NAME information from qcsiteadmin_db.td.users from a business view? We have a need to provide a person's full name in addition to the user name that is used throughout HP ALM for BG_RESPOSIBLE, BG_DETECTED_BY, TS_RESPONSIBLE, etc. The USERS table in each project has ...

Hello. I have been asked to create a report for a team that will provide the test cases along with the "Actual" results from all the test cases that have been run.  I was able to pull together all the data, but I'm stuck with narrowing down the info to one line per test case. If it was just the test...

Hello. I am trying to create a query that will provide a report containing the run times broken down into seconds, minutes, etc. So far, I have the following query, but I keep receiving an error. Can you help me with this? Thanks! SELECT rn_test_id, sum(rn_duration) as sec, sum(rn_duration) / 60 as ...

Hello. We have a report that we run in ALM to display the manual test steps that have been executed, and we are receiving negative values in the report, when all the steps in the TC has been run successfully. We found that the tests in Test Lab had fewer steps than the same instance in Test Plan. Th...

I was informed that the TLS Bridge for our DEV ALM application server will be targeted (via deployment) tonight to disable TLS 1.0 & 1.1 and enable TLS 1.2 followed by a reboot. Are there any known issues that can occur? I plan to validate normal ALM UI & Site Admin functionality but is ther...

I'm prepping for a software upgrade engagement for our on-site ALM installation. Unfortunately, I don't have the original Database Administrator's password. A few questions: Are the original Database Administrator credentials needed for the upgrade? If yes, is it possible to change the password usin...