Purge Data Using the Utility

About this task

This topic describes how to purge alarms using the Proficy Historian Alarm and Event Data Migration utility. You can also purge them at a command prompt.

Before you begin

Ensure that you are a member of the ihsecurityAdmins security group.

Procedure

  1. Run the Proficy.Historian.AandE.Migration.exe file. By default, it is located at C:\Program Files (x86)\Proficy\Proficy DataBase.
    The Proficy Historian Alarm and Event Data Migration window appears.
  2. Select Purge Alarms.
    The Purge Alarms section appears.
  3. Enter values as described in the following table.
    Field Description
    SQL Instance Name Enter the Microsoft SQL server instance that contains the data that you want to purge.
    Database Name Enter the name of the database that contains the data that you want to purge.
    Authentication Select Windows or SQL depending on whether you want to provide credentials of the Windows machine or the SQL server, respectively.
    User Id Enter the User ID of the Windows user or the SQL user (depending on whether you have selected Windows or SQL).
    Password Enter the password of the Windows or SQL user account (depending on whether you have selected Windows or SQL).
  4. Select Connect.
    A message appears, specifying that a connection to the Microsoft SQL database is established. The Space Consumed (MB) and the Alarms and Events count fields are populated with the appropriate values.
  5. If you want to purge data within a time range, provide the start time and end time in the From and To fields, respectively.
  6. If you want to purge data for a certain duration till the current date and time, enter a value in the Retention field, and then select the units of measurement. The default value is 1 minute.
    If you want to purge data until last week, enter 7, and then select Days. Data from the beginning until seven days prior to the current date and time is purged.
  7. Select Begin Purge.
    The data received within the specified duration is purged. You can check the log data in the Proficy.Historian.AandE.Migration.log file. By default, this file is located in the C:\Program Files(x86)\Proficy folder.

    In addition, an audit log is created at ..\Proficy Historian Data\LogFilesfolder.