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. ^_^