Process - Reporting Rework Faults

The intention is to standardize the way that DevOps cases are documented, so that the issues list can identify rework bugs and what caused the issue.

Using

Devops/Queries.

Configuration

For reference, see Queries/Shared Queries/CTY/CTY Logs Entered by TW.

Create a query with the following columns:

• Title
• Assigned To
• State
• Sub state
• Priority
• Severity
• Created Date
• Tags
• Work Item Type
• Bug Type
• Fault
• Hotfix in Release

Add criteria to select the data, typically:

• Work Item Type - Any
• State - Any
• EITHER/BOTH/NEITHER - depending on requirements.
  • Tags contains - select your tags
  • Custom Customer Contains - Enter a part of the customer

If possible, use a shared query or create a shared query .

Create a DevOps Bug List spreadsheet from template.File:Client BugList Analysis.xltx

Exporting

Run the Query.

Use the triple-dot menu on top right.

Choose Export to CSV

Open CSV

Copy all data (minus headers)

Open DevOps BugList spreadsheet

Paste data into first tab (DevOps Logs).

Go to second tab (Analysis)

Click Data/Refresh All.

Save.

The Analysis tab will break down the issues in the list and summarize the data.