I wish to create a validation query which returns (not closed) incidents that have no open assignment (not currently assigned to any support group or analyst).
Step by Step:
You can do this via query tool:
- Create a new query
- Select the Incident object
- Ensure the criteria is "incident.status.name not equal to 'closed'"
Then look at the Current Assignment collection on the incident object.When all the assignments have been completed the current assignment is changed back to NULL.
Cf. How To: Understand the difference between a Current Assignment and Latest Assignment?
- Therefore the criteria should be incident - current assignment - group and incident - current assignment - user is NULL.
Service Desk Console all versions