Austin Agile DevOps

DevOps in the Cloud
posts - 70 , comments - 7 , trackbacks - 0

Agile SCM Talk Blog

Postings migrated from my old blog sites
Passing in report parameters to TFS 2010 OLAP Web Parts on the Team Portal
There is some helpful information from Ewald Hofman on passing in parameters to the TFS SQL Server Analysis Services OLAP reports. But, the 2010 schema has changed. You can use the SQL Server Mgmgt Studio to access the metadata and query the tables to seee the new schema and record values. As an example of the Task Burndown report on the TFS 2010 Project Portal, here's the URL that worked in a browser: http://{your tfs server}/Reports/Pages/Repor... ......

Posted On Tuesday, May 15, 2012 8:48 AM | Comments (2) | Filed Under [ Agile SCM Talk Blog ]

How I Customized Report Parameters for Team Foundation Server 2010
My goal was to have the burndown chart on the team project portal main page display the current iteration. The default report displays the tasks for the entire team project starting 5 days before the current date and ending 25 days after the current date. FRUSTRATING, to say the least! I mean, what a useless report! Who's Agile book did they get that one from? What I wanted was to see the burndown for the current iteration. That is, tasks for that iteration only and that iteration starting on a fixed ......

Posted On Tuesday, May 15, 2012 8:46 AM | Comments (0) | Filed Under [ Agile SCM Talk Blog ]

Using a TFS 2010 custom bug work item definition with the MTLM Test Runner
We don’t use the term “Bug,” rather we use “Software Action Request” or “SAR.” I renamed the Bug WI definition from Bug to SAR. I added a few custom fields to our SAR WI definition, but all the Microsoft fields are used and unchanged. What I want is for the MTLM client to be configured to open a SAR rather than a Bug. In other words, out-of-the-box when a user is manually executing a test case with the MTLM Test Runner client and one of the steps fail, the user clicks a button to create a Bug or ......

Posted On Tuesday, May 15, 2012 8:44 AM | Comments (0) | Filed Under [ Agile SCM Talk Blog ]

Updating an incorrect reason code after a state transition
When using TFS work items you may find that when you transition from one state to another that you selected the wrong reason code, or you found out shortly afterwards that the reason code you selected is incorrect. Well, you may be surprised to find that reason codes (System.Reason) cannot be updated within the same state. After some looking into, I came to understand the intent of reason code is to document the "reason" the state changed. As opposed to indicate within state changes. However, it ......

Posted On Tuesday, May 15, 2012 8:32 AM | Comments (0) | Filed Under [ Agile SCM Talk Blog ]

Set Lab Management (LM) Permissions for Team Projects Created before LM was Configured
What a long title! Anyway, I didn't add LM until sometime after I had setup my Team Foundation Server 2010 instance. There are 2 important realities to face when you do this: The LM permissions in the process template are not applied because LM was configured when the team project was created There's no UI to set LM permissions (arrrgh) All you have are the permissions established by the accounts used to setup LM (i.e. TfsSetup, etc...). Here are the commands I developed to grant permissions to existing ......

Posted On Friday, October 7, 2011 2:38 PM | Comments (0) | Filed Under [ Agile SCM Talk Blog ]

Team Foundation Server 2010 Real-Time Burndown Charts
The reality is that project managers need work status in real-time. The TFS Excel reports and web parts are great, but because they are sourced from the TFS SSAS cube the information can be up to 2 hours old. The User Story goes like this... "As a project manager, team lead or team member I want to see what work is currently active and what the burndown is by team and by person is for that work so I know when work delays or time reporting failures are taking place. I need to know this 30 seconds ......

Posted On Friday, September 30, 2011 2:36 PM | Comments (1) | Filed Under [ Agile SCM Talk Blog ]

TFS 2010 Agile Iteration Burndown Chart Error - Could not connect to server...: ensure SQL Server Analysis Services is running
It seems there are many issues that can cause this error. But in my situation it turned out to be a permissions issue. It appears that other TFS 2010 reports use the service account (i.e. TFSReports) to access SSAS. However, it seems that the burndown chart in the TFS MSF v5.0 Agile Iteration Backlog Excel file passes the current user credentials to SSAS to get chart data. As only the TFSReports account had access, the burndown chart request was denied resultign in the error noted above. To fix this ......

Posted On Monday, August 8, 2011 2:30 PM | Comments (0) | Filed Under [ Agile SCM Talk Blog ]

TFS 2010 Web Part for Data Warehouse Views
Team Foundation Server 2010 includes support for Data Warehouse and Analysis Cube Views. The company, Amrein Engineering, sells a web part that uses SQL statements to source data. You can implement this web part very easily to do some very nice reporting of TFS data. For example, you cannot use "time" as a query criteria in Team Explorer. You can only use the date. That is, you can ask for all work items changed by Joe Black on 9/11/2011. But you cannot ask for changes between 3 and 4 PM on that ......

Posted On Friday, September 9, 2011 2:33 PM | Comments (0) | Filed Under [ Agile SCM Talk Blog ]

Publish TFS 2010 Last Work Item History Comment to Excel
Team Foundation Server 2010 does not support publishing history data to Excel. However, there is an easy work around to this problem. However, this is limited to the last recorded History comment for a work item. This is what displays in the query return set when the History column is included. Create a query with History as a column Run the query Click the pulldown on the "Open in Microsoft Office" button Select "Send Query to Microsoft Outlook" An email pops up with the data in a table that includes ......

Posted On Tuesday, September 6, 2011 2:31 PM | Comments (0) | Filed Under [ Agile SCM Talk Blog ]

Microsoft Test Manager (MTM) fails to connect when executing test run
If you are logged on to the local machine (not the domain) you will be prompted to enter network credentials when you open MTM to connect to TFS. However, if you receive a connection error when you attempt to run a test case, you may want to try the following work around. Go to the Test Plan Select properties Select you Test settings under Manual Runs Uncheck the ASP.NET Client Proxy collection Save and use that Test Settings Configuration to run a test case ......

Posted On Wednesday, August 24, 2011 2:30 PM | Comments (0) | Filed Under [ Agile SCM Talk Blog ]

Full Agile SCM Talk Blog Archive

Powered by: