Counting records that use the target value in specified fields


Before you modify data, you can use the data wizard to count records that use the target value. For example, if you plan to change a site name from Canada to Canadian HQ, the data wizard provides the following information:

  • All forms that reference the Site Name field
  • The number of records on each form that contains the target value such as, "Canada", in the example.

To count records that use the target value in specified fields

  1. Access the data wizard.
    1. Log in to the AR System server as an administrator.
    2. From the Applications list on the IT Home page, select Data Management > Data Wizard. Data Wizard Console is displayed as shown in the following figure.
    3. 221_Data_Wizard_Console.png
  2. Select the Count target values action.
  3. Select the data that you are counting.
    Select any of the following types of data:
    • Company Name
    • Person Name
    • Login ID
    • Generic Categorization
    • Operational Categorization
    • Product Categorization
    • Product Model / Version
    • Site Name
    • Site Information
    • Support Group
  4. When you select the type of data, a window appears, prompting you for the target value. Enter or select the target value.
    1. For some types of data, you might specify values for multiple fields.
      For example, for Product Categorization, you can specify multiple tiers of categorization.
    2. For some types of data, you can specify search criteria to locate the appropriate original value.
      For example, for Person Name, you can specify the Company Name.
      221_datawizard-counter.png

  5. Click Go.
    You are prompted to confirm whether to proceed.
    When you proceed, the Data Wizard Status window appears, listing forms to be counted. As the count proceeds, the status changes from Pending to Complete.
    If you close the Data Wizard Status window, you can open it by clicking View Status.
    You cannot open this window after the count is complete.

For information about viewing the audit log, see Viewing the audit log for count records.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*