Is there a query to get a list of projects that haven't had any data written to Project
Tracker artifacts?
This script will show empty projects:
select MODULE_ID from SCARAB_ISSUE
left outer join SCARAB_TRANSACTION on
(TRANSACTION_ID = MODIFIED_TRANS_ID
AND CREATED_DATE > '20061120130400')
WHERE TRANSACTION_ID IS NULL AND MODULE_ID != 1;