Geo SCADA Expert

Historic Data Generator

A new tool has been created for generating historic data. This can easily create large amounts of test data for profiling the performance of a system.

This tool is a new command called HISGEN in the ClearSCADA command line application (which is called ScxCmd.exe).

Syntax


SCXCMD HISGEN <path> <type> <period> <density> [Recurse] [<threads>]


Where:

  • <path> -- Folder where historic is located.
  • <type> -- Type of historic to generate (matches file extension):
    • HRD – Raw data
    • HMD – Modified data
    • HAD – Annotation data
    • HSD – Suppression data
    • MWJ – Event journal data
    • CCS – Configuration changes data
    • ALS – Alarm summary data (6.76 onwards)
  • <period> -- Number of granules to generate, starting with previous granule.
  • <density> -- Number of records per granule.
  • Recurse -- Optional, recurse through sub-folders below <path>.
  • <threads> -- Optional, number of threads to generate data in parallel.

Examples


SCXCMD HISGEN "C:\ProgramData\Schneider Electric\ClearSCADA\Database\History" HRD 52 672 RECURSE 32

This will generate 1 year (52 weeks) of 15 minute (672 records per week) raw historic data for every point using 32 threads.


SCXCMD HISGEN "C:\ProgramData\Schneider Electric\ClearSCADA\Database\Journal" MWJ  168 3600 RECURSE 16

This will generate 1 week (24*7) of 1 second (3600 records per hour) event data across all objects using 16 threads.


SCXCMD HISGEN "C:\ProgramData\Schneider Electric\ClearSCADA\Database\History\Historic\HdI00000\000123" HRD 10 168

This will generate 10 weeks of 1 hour (168 records per week) raw historic data for a single point (object Id 123).


Notes

  • The server must be shutdown whilst generating the historic data.
  • All points must be created prior to generating the historic data. The tool generates data for existing points only.
  • All values generated are 0 with good quality
  • The scxcmd executable exists with 'C:\Program Files (x86)\Schneider Electric\ClearSCADA' on 32-bit machines