Scheduling automatic usage data collection

Since usage data collection is a resource-intensive task, it is not set up to run periodically when you install the system. However, if you need to collect usage data at specific intervals, you can set up automatic usage data collection.

Usage data is displayed on the usage summary page.

To set up automatic usage data collection:

  1. Log in to the SQL server as domain administrator.

  2. Click Start, point to Programs, point to Microsoft SQL Server, then click Enterprise Manager.

  3. Select your SQL server, then expand Databases.

  4. On the database list, select Ensim_WVH_Configuration.

  5. Expand the Tables list.

  6. On the Tables list, right-click CronJob, point to Open Table, then click Return All Rows.

  7. Click the bottom cell of the table to add a row, then insert the following information in the columns of the new row:

  1. Leave the first column, the ID, blank. The system completes this column.

  2. In the Name column, type the following name: UsageMonitor.

  3. In the Interval column, enter the frequency of the usage collection task, in seconds. For instance, if you want the task to run once every day, type 86400 (24 hours x 60 minutes x 60 seconds = 86,400). If you want to run the task once every hour, type 3600 (60 minutes x 60 seconds = 3,600). Since the data collection task is resource intensive, set the interval to no less than 3600 seconds (once every hour).

  4. In the Last Run column, type the current date and time.

  5. Press Tab twice to enter Null for the last two columns of the row.

  1. Save and close the table.

  2. Stop the Provisioning Engine COM+ service:

  1. Log on to the Provisioning Engine (PE) server as domain administrator.

  2. On the PE server, click Start, point to Programs, point to Administrative Tools, then click Component Services.

  3. In the left navigation bar, expand Component Services -> Computers -> My Computer -> COM+ Applications -> Provisioning Engine.

  4. Right-click Provisioning Engine, then click Shut down.

When you log in to the control panel, the Provisioning Engine COM+ service is restarted, and usage data is automatically collected at the interval you specified.

Usage data displayed in the control panels is updated automatically at the interval you specified.