HP QC / ALM - How to use SQL query to identify what artifacts has been checked out?

While administering HP QC / ALM project with many users in it, ever thought what's the best way to identify which artifacts have been checked out and who have it checked out?

Below is the query to use:

(1) Do note that this only applies to "Test" module only.

SELECT * FROM TD.TEST
WHERE TS_VC_STATUS = 'Checked_Out'
AND TS_TEST_ID IN (SELECT TS_TEST_ID FROM TD.VC_TEST)

(2) There would be similar query for "Resource" module, "Requirement" module, etc.

You just need to identify the correct table to query. Cheers. ^_^

How to disable email notification every time a defect field is updated in Quality Center?

My organization uses MS Sharepoint for all project tracking, communication and documentations. This being said, defect log is also tracked in MS Sharepoint. However, my organization has HP ALM/QC as well and the management knew HP ALM/QC provides better defect analysis reports.

Somehow, the idea of using another application to track defect log seems like a pain to them (even though it is known that the application can track it better). Anyway, the main point here is MS Sharepoint is used as the front-end to track defects and subsequently being synchronize back to HP ALM/QC for reporting purpose.


Certain level of workflow has been implemented in MS Sharepoint to make it as interactive as possible (e.g. sending an email notification when the defect is being assigned). However, this feature is already built-in in HP ALM/QC, it means that when the defect is synchronized to HP ALM/QC, another notification is sent again. (Oops...)

So, I did some googling to find out how to disable this built-in feature and noticed how easy it is:

(1) Login to Site Admin.
(2) Under Site Projects, select the project that you want to disable this built-in feature.
(3) Under Project Details, uncheck Send Mail Automatically check box which can be found under the title Miscellaneous.

 What does it do? Here you go, please read:



Cheers. :)

Updated note:
(1) After some thought, I was wondering if this option will also disable the auto email notification for test automation. Let me know if you have any idea? Thanks. :)
Answer: Found the answer from HP community forum, refer here. The answer is no - disabling the auto email notification will not impact notifications set up for test lab.

How to turn off e-mail notification when adding new users in Quality Center?

Having you right here, I believe you are a project administrator who receive email notification like below before.

From: xxx
Sent: Monday, January 01, 2015 01:00 AM
To: yyy
Subject: User added to project Sample_Project

This is an automatic message sent to you as an administrator of project 'Sample_Project' in domain 'Sample_Domain'. The following users were added to the project by the site administrator 'You' (by QC server XYZ):dummy_user

It will be like a spam when the amount of users added is a lot. So, action on below:

By default email notifications are sent to the project administrators when new users are added and removed from a project in Site Administrator. 

AUTO_MAIL_USER_NOTIFICATION is an optional Site Configuration paramater to toggle the notification functionality on and off. 

This parameter enables you to prevent Quality Center sending automatic email notification to project administrators when users are assigned or removed from a project in Site Administration. 

If this parameter is set to "N", then automatic notification is not sent to project administrators. If this parameter does not exist, is empty, or is set to "Y", then automatic notification is sent.

To disable automatic notification perform the steps below:
1. Login to the QC Site Administrator
2. Navigate to the Site Configuration Tab
3. Click the New Parameter Button
4. Enter AUTO_MAIL_USER_NOTIFICATION for the parameter field
5. Enter N for the value field

This is the sample result when it is done, and tested working. 

Cheers. :)