Access Archive Statistics

About this task

You can access a list of selected statistics about an archive file. You can specify the server, the archive file name, and the type of information you want to access (such as start time, end time, file name, target file size, current file size, current or read-only status, last backup time, and last backup users). You can also specify a range of cells for the display.

Procedure

  1. Open an Excel worksheet.
  2. Select Historian > Administration > List Archives.
    The Historian Archive List window appears.
  3. Select a server from the drop-down list. If you do not specify a server, the default server is considered.
  4. Enter values as described in the following table.
    Field Description
    Archive Name Enter a archive name. Do not use wildcards in this field.
    Tip: To return details for more than one item, specify a substring in the Archive Name field that exists in each archive you want listed. For example, if you have archive files named from Hero5_Archive001 to Hero5_Archive010, enter Hero5_Archive to return the details for all those archives.
    Output Display Select one or more parameters for the output display.
    Output Range Select a range of cells in a single row or column to determine where the returned data is placed.
  5. Select Asc or Desc to sort the archives in ascending or descending order.
  6. Select either Columns or Rows for the output display.
    Note: When selecting multiple tags, the orientation of the return data is based on the orientation of the selected tags and the Row/Col selection is ignored.
  7. Select OK.
    The statistics of the selected archives appear.