Friday, February 05, 2016

Get all project valid users from TFS

Get all project valid users from TFS using CMD Open the developer command prompt and execute the below command by changing the collection URL TFSSecurity.exe /imx "Project Valid Users" /collection:http://ws2012r2:8080/tfs/FabrikamFiberCollection output: Microsoft (R) TFSSecurity - Team Foundation...

List of project admins from active projects who have accessed TFS 2015 at least once in past 6 months

List of project admins from active projects  who have accessed TFS 2015 at least once in past 6 months using SQL query CREATE TABLE #TB1_PROJECTNAMES (cdate datetime,cid int,fpath nchar(1000)) CREATE TABLE #TB1_ACTIVEPROJECTNAMES (ID INT IDENTITY(1,1),ChangedDate datetime,ChangesetId...

All project admins in collection

Get all project admins in collection using SQL query USE Tfs_FabrikamFiberCollection SELECT member.SamAccountName,grp.Displayname FROM     [ADObjects] grp     JOIN ADObjectMemberships om ON om.ObjectSID = grp.ObjectSID     JOIN ADObjects...

List of project admins from active projects who have accessed TFS at least once in past 6 months

List of project admins from active projects  who have accessed TFS 2013 at least once in past 6 months using SQL query USE Tfs_FabrikamFiberCollection CREATE TABLE #TB1_PROJECTNAMES (cdate datetime,cid int,fpath nchar(1000)) CREATE TABLE #TB1_ACTIVEPROJECTNAMES (ID INT IDENTITY(1,1),ChangedDate...