We are currently (badly) using Self Service to take lunch requests for our company.
Each week, users can select one of 3 options for each day.
This then goes through to our catering team who make up the requirred lunch.
Unfortunately, when this was put in, it was only configured so that the request goes to "Submitted", and then nothing further is done with the request.
Therefore we currently have approox 33,000 Service Requests outstanding at Submitted...
As you can imagine, this isn't ideal.
We are going to be upgrading shortly to the new version of Ivanti, and would like to clear this down.
I can't think of a way to run a workflow or Quick action without going into each request individually and moving to the completed status.
Is there anything anyone can think of to mass close the open tickets? Whether that be via a DB Script or something in the front end?