-- 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;