Is there a way to unlock all the locked projects without selecting them one by one?
All Supported versions
You can clear the locks by going to the url and add 'security.locks' in the url after 'action:' otherwise you would have to check for the prlock from the database.
Important: It's recommended to only unlock a project using this method if you have validated it is correct to unlock. Projects may be locked by users intentionally for scheduling updates, including via Open Workbench or Microsoft Project.
Steps to clear the locks below:
If the project that is locked does not appear from this page, please open a case for an approved query to validate and delete from the PRLOCK table.
See also Locked Projects - Known KBs/Issues