This isn't the official script distributed by Blue Prism (as @Jerry pointed out the existence of), but one I've used against several installations to force a reset of the password.
Blue Prism v6
This finds the user with the username
admin and resets their password back to the original
adminstring. It will force a password change for
admin on their next logon.
USE blueprism UPDATE BPAPassword SET salt = '', hash = '208512264222772174181102151942010236531331277169151', type = 0 WHERE userid = (SELECT userid FROM BPAUser WHERE username = 'admin')
Blue Prism v5
This script will change every user in the environment's password back to
admin, but will not force a password change on the next log in. There is likely a more elegant way to do this and target just the
admin user, but unfortunately I no longer have access to a v5 schema to test this on.
USE blueprism UPDATE BPAUser SET password = '208512264222772174181102151942010236531331277169151'