Database table where Checkin Policy configuration is stored?

Question

Hi,

I'm trying to build a report where I need to get the Checkin policies (eg. Code Analaysis policy) configured for the project and the number of policies violated. I'm trying to figure out the database and the table where these data are stored, so that I can get the data from the corresponding table. Please help me in this regard!!

Thanks in advance,

Yuva

Answer 1

Hi Yuvaraj,

Try to connect to SQL Server TfsVersionControl database;

Query table tbl_Workspace, for example, select * from tbl_workspace where workspacename=’user name’ 

Query table tbl_PendingChange , tbl_PolicyFailure and tbl_PolicyOverride to find the information what you want.

 

Hope it helps!

If you have any concern, please feel free to let me know!

Best Regards,

Cathy Kong

Answer 2

Hi Cathy Kong,

tbl_Workspace gives the workspace level configuration whereas all i need is the Checkin Policies configured for the Team Project by the Project Administrator. The checkin policy like Code Analysis Policy may be set the administrator for a Team Project and choose certain rules. I need the database table where these values are stored.

Thanks in advance,

Yuva

Answer 3

Hi

We're struggling with the exact same question. Is it possible to get a proper answer? We know about the override and failure tables but they are just historical entries. Where is the actual configuration? We have been running TFS since V2005 and we need to clean up and get control of which versions of which policy we actually have running. Where is the strong name for the classes that contain each policy?

Regards
Martin Moe

---

Martin "Brumlemann" Moe