How do I enable all profiles at once?

Products

Webtrends Analytics 8.1x
Webtrends Analytics 8.0x

Cause

On a Webtrends installation running MySQL, there are a large number of profiles that have been disabled and you want to enable them all at once, rather than enable each one individually.

Resolution

1. Open a command line window on the Webtrends server and navigate to the following folder:

\Webtrends\common\database\mysql\bin\

2. Type the following command:

mysql.exe -u-p

Replace with the username chosen for the MySQL database at the time of installation. This is “Administrator” by default.
Replace with the password chosen for the MySQL database at the time of installation, and omit the space between -p and the password. This will display the password on the line above, instead of prompting for it and hiding it after hitting Enter. By displaying it above you can verify that no mistakes are made when entered.

3. Type the following commands and hit Enter after each line:

use wtmaster;
update wt_profile set profilestatusid = 1;

4. Type “quit” to exit the MySQL command shell.

Log back into Webtrends and confirm that all events have been enabled.