Unassigned work report in Azure DevOps
Every Monday, email incomplete work items with no assignee, excluding Proposed (New, To Do, …) in Azure DevOps.
This automation sends an email every Monday listing these unassigned work items, excluding those in the Proposed state category. Before enabling, you'll need to set the email recipients and your timezone.
Prerequisite: Install Automations App on your Azure DevOps organization
Trigger — Schedule
This step triggers the automation to run on a recurring schedule. It is set to activate every Monday at 09:00 UTC.
Configured in this template
- Occurrence: Every Mon at 09:00 (UTC)
You can customize
- Change the day or time of the week to fit your reporting needs.
- Adjust the timezone if your team operates in a different region.
Get — Search work items
This step searches for work items that match specific conditions: no assignee, no closed date, and not in the Proposed state category. It loads up to 200 items.
Configured in this template
- Field conditions:
- - Assigned To Is Empty
- - Closed Date Is Empty
- - State <> state category Proposed (New, To Do, …)
- logic: and
You can customize
- Modify the field conditions to include other states or fields.
- Use a shared query for more complex filtering needs.
Action — Send customized email
This action sends an HTML email listing the unassigned work items. The email is sent from notifications@documentero.com and includes a customizable subject and body.
Configured in this template
- To: (empty — add recipients)
- From: notifications@documentero.com
- Subject: `Unassigned work (
{items.Count}items)` - Body (HTML): `<p>Incomplete work items with no assignee (excluding New / To Do):</p><ul>
{#Items}<li><a href="{Url}">#{Id}{Title}</a></li>{/Items}</ul>`
You can customize
- Add email recipients in the 'To' field.
- Edit the email subject and body to match your team's communication style.
- Include additional information in the email body as needed.
Full automation
Common questions
How do I unassigned work report in Azure DevOps?
What fields must be filled before enabling the automation?
Can I change the work item types included in the report?
How can I test the automation before it runs on schedule?
How do I adjust the schedule to a different timezone?
Visual Studio Marketplace
Automations
Automate Azure DevOps workflows with triggers, actions, conditions, and scheduled rules.
Other Schedule & bulk templates in Automations.
Stale work report
Every Monday, email incomplete work items not changed in 14+ days (Closed Date empty). Adjust the stale window, or add work item types (Bug, User Story, Task) if the list is too broad.
Weekly closed work report
Every Monday, email a report of work items whose Closed Date is in the last 7 days. Closed Date covers Done as well as Closed.
Close resolved work after 30 days
Daily, find items in the Resolved state category unchanged for 30+ days, set State to Completed (Closed or Done for the work item type), and add a comment (max 50 per run; the rest wait for the next day).
Bulk assign from a query
On a schedule, run a shared query and set Assigned To on matching items (max 50).