by XDK
4. November 2014 07:26
Explanation:
All MTM objects information are stored in the TFS collection database table ‘tbl_AuditLog’.
Solution:
You can query the TFS collection database table ‘tbl_AuditLog’ as below
USE <TFS collection database>
SELECT tbl_AuditLog.AuditId, tbl_AuditLog.DateModified, tbl_AuditLog.Action, tbl_AuditLog.ObjectType, tbl_Project.ProjectName, tbl_AuditLog.AuditIdentity FROM tbl_AuditLog JOIN tbl_Project ON tbl_AuditLog.ProjectId = tbl_Project.ProjectId
List of Action code:
None = 0
Delete = 1
Reset = 2
List of Object Types:
None = 0
TestRun = 1
TestConfiguration = 2
TestPlan = 3
TestPoint = 5
TestResult = 6
TestVariable = 7
TestResolutionState = 8
TestSettings = 9
Attachment = 10
TestSuite = 11
TestSuiteEntry = 12
TeamProject = 13
TestVariableValue = 14
TestConfigurationVariable = 15
BugFieldMapping = 16
Session = 17
TestController = 18
DataCollector = 19
TestCase = 20
SharedSteps = 21
Other = 1000
You can query the TFS configuration database table ‘tbl_Identity’ for user details
SELECT [Sid],[Id],[DisplayName],[Domain],[AccountName],[MailAddress] FROM [Tfs_Configuration].[dbo].[tbl_Identity] where [Tfs_Configuration].[dbo].[tbl_Identity].[Id] = '<tbl_AuditLog.AuditIdentity value>'
f4bec958-72e4-4450-9fd5-5b47949096c7|0|.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04
Tags: TFS 2013 TFS 2013
MTM
by XDK
30. September 2014 12:59
Solution:
1. Open the team project web portal
2. Goto Test tab --> select a test suite --> click on “View List” --> click on “Grid” to view the testcases for bulk edit.
948e9dbb-9220-4490-979b-743e31be501e|0|.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04
Tags: TFS 2013 TFS 2013
MTM