-- Replace 'YourCollectionDB' with your actual collection DB name.
-- This query gets changesets and changed files under the PRD branch path.

SELECT 
    cs.ChangesetId,
    cs.CreationDate,
    cs.Comment,
    u.DisplayName AS CheckedInBy,
    f.ServerItem AS FilePath,
    ch.ChangeType
FROM 
    tbl_Changeset cs
JOIN 
    tbl_Change ch ON cs.ChangesetId = ch.ChangesetId
JOIN 
    tbl_Version v ON ch.ChangeId = v.ChangeId
JOIN 
    tbl_File f ON v.FileId = f.FileId
JOIN 
    tbl_Identity u ON cs.OwnerId = u.IdentityId
WHERE 
    f.ServerItem LIKE '$/YourProject/Main/PRD%' -- Adjust this to match your PRD branch path
ORDER BY 
    cs.ChangesetId DESC;