We cannot provide a sql script or the commands to close multiple CSRs as it is a complex process and as with most updates to the database, is not a supported activity. To give you an example, here’s a is list of checks that Stat has to perform in order to Close a CSR:
- All CSR objects are unlocked. Release object locks and reservations.
- CSR Workflow has to be ready to transfer to a closed status.
- Resolution has to be entered. Provide a resolution (this requires user interaction)
- User has access right to update CSRs to a closed status
The code to do these things are in and different places for the different components (web and client app).