To shorten the time period before the "Deleted Data Cleanup" event permanently deletes a profile and its data, perform the following steps:
1. Open a command line window and navigate to the following directory:
\Webtrends\common\database\mysql\bin
2. Type the following command to open the MySQL command shell interface:
mysql -u <user name> -p
By default, the user name is "Administrator" (without quotes). If a different name was chosen during installation, enter it here. You will be prompted for a password. This is the password entered for the MySQL user account at the time the product was installed.
3. After entering the password, type the following command and press Enter:
use wtmaster
4. Enter the following query. If a row is returned write down the value:
SELECT id FROM wt_app_profiles WHERE profile_name = 'deletedprofilecleanup.ini';
5. Enter the following query. If a row is returned write down the value:
SELECT id FROM wt_app_sections WHERE section_name = 'default';
6. Enter the following query. If a row is returned write down the value.
SELECT id FROM wt_app_tokens WHERE key_name = 'daysuntilprofiledeletion';
7. Enter the following query. Replace <new value> with the number of days after a profile is deleted that the data should be deleted and use the values from the previous three steps for the rest of the parameters:
UPDATE wt_app_confdata SET data = '<new value>' WHERE profile_id = <value from step 4>AND section_id = <value from step 5> AND key_id = <value from step 6>;
If <new value> is set to 0, deleted profiles, their analysis data and the disabled analysis event will be deleted the next time the "Deleted Data Cleanup" event runs.
8. Type "exit" and press Enter, then close the command line window.
|
