SELECT c.ParentPath,c.ChildItem,
c2.SamAccountName,
DATEADD(hh,8,cs.CreationDate) CreationDate,
cs.Comment
FROM    tbl_Version c
JOIN    tbl_Changeset cs
ON      cs.ChangeSetId = c.VersionFrom
JOIN    tbl_Identity owner
ON      owner.IdentityId = cs.OwnerId
JOIN ADObjects c2 ON c2.TeamFoundationId = owner.TeamFoundationId
LEFT JOIN tbl_Identity committer
ON      committer.IdentityId = cs.CommitterId
LEFT JOIN tbl_PolicyOverride po
ON      po.ChangeSetId = cs.ChangeSetId
--WHERE   cs.CreationDate >= DATEADD(hh,-8,CONVERT(VARCHAR(10),GETDATE(),120))
ORDER BY CreationDate DESC