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).
SCXCMD HISGEN <path> <type> <period> <density> [Recurse] [<threads>]
- <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.
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).
- 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