Warning: Undefined array key "HTTP_REFERER" in /www/wwwroot/prod/www.enjoyasp.net/wp-content/plugins/google-highlight/google-hilite.php on line 58
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