Created On:  20 October 2010

Problem:

What tools can I use to disable all user accounts apart from the admin account?

Resolution:

The IVQL tool can be used for this, open a command prompt and enter the following:

1. IVQL SQMDB
2. UPDATE User_v300_p SET account_state = 1 WHERE account_state = 0 AND user_id != “admin”
3. Commit
4. Quit
5. Dbmgr –stop
6. Dbmgr –start

Admin can be replaced with another administrative account. Contact Supportline for a copy of the IVQL tool stating the version of CaliberRM Server you are using.