The purpose of this article is to be a reference for Aggregation part of the full Data Collection Module documentation
Prerequisite: A Starter package (SiteManager + accounts) A device capable of supporting data collection via 1 of the DCM protocols Samplepoints where the aggregation can get data from	Other sections in DCM: Getting started Guides Examples Frequently asked questions Troubleshooting

Data that you can collect from SiteManager itself is:

"SystemTemperature" (in centigrades Celcius)
"CPULoad" (in percent)
"FreeMem" (in kB), "UTCRTC" UTC Real TIme Clock broken into 8 separate values
"DigitalInput" (as 0/1)
"IngressRate" (in bytes/s)
"EgressRate" (in bytes/s)
"DBCachesize" (in bytes)
"DBSize" (in bytes)
"GSMRssi" (in dBm)
"GSMBer" (in percent)
"GSMOperator" (text string)
"GSMTechnology" (text string: "4G", "3G", "GPRS" etc.).

The General config elements contains the following fields:

Function	Type	Importance	Description
ConfigName	string	mandatory	Unique name for this configuration file. Follows the rules for names. ConfigDescription (string, optional) text describing this configuration.
CheckpointInterval	integer == 0 or >= 60	optional	The interval with which all data from the internal datasample cache is saved to disk. This more unstable (power) the SiteManager, the more often data should be saved. Saving it often, however will also cost performance and wear on the hard-disk/flash. A value of 0 means, never checkpoint, otherwise it means interval in seconds between saves. If not specified the value 15 * 60 (15 minutes) is used.
AlarmsSaved	integer >= 4	optional	The number of alarms saved in the store-and-forward database. If this values is not specified, it will default to 32.
WaitForNTP	boolean	optional	Synchronize DCM data collection with NTP time. If this parameter is true, all DCM collectors will not begin collecting data until NTP is enabled and configured and NTP has synchronized date/time. If not specified, the value is true. Mostly used for troubleshooting

The Collectors (array of objects, mandatory) list elements contains the following fields:

Function	Type	Importance	Description
CollectorName	string	mandatory	which is unique name (within this configuration file) of a device to collect data from. (This is the name used in the agent configuration). Follows the normal rules for names.
CollectorDesription	string	optional	description of this collector.
CollectorIPAddr	string	optional	provides a default IP address (or DNS name) for the device to be polled. The agent Target IP address will take precedence over this.
CollectorPortno	integer > 0 and < 65535	optional	provides the default port number for the device to be polled. The agent Target Port number will take precedence over this. If neither CollectorPortno, nor agent Target Port Number is specified, the appropriate port will be used, depending on the Protocol parameter value.
Alias	string	optional)	This is the CollectorName of another collector, from which, all the parameters (expect CollectorName, CollectorDescription, CollectorIPAddr and CollectorPortno) are copied from. An alias cannot refer to another alias.
Protocol	string-enum	mandatory	the protocol used to collected data. Currently 7 possible values exists: "OPC-UA/TCP", "Modbus/TCP", "S7/TCP", "Http/GET", "Rockwell", "Simulator" and "Internal".
ConnectRetryMin	integer > 0	mandatory	Minimum number of seconds before trying to reestablish a connection to the device being sampled. An exponential back-off algorithm is used to retry connection establishment, starting after ConnectRetryMin and increasing to ConnectRetryMax.
ConnectRetryMax	integer > 0	mandatory	Maximum number of seconds before trying to reestablish a connection to the device being sampled.
SamplePoints	Array of objects	mandatory	List of samples to be collected, possibly aggregated and stored in the Store'n'Forward database.

Samplepoint items

The SamplePoints objects contains the following elements:

Function	Type	Importance	Description
SampleName	string	mandatory	Name of this sampled value (sometimes called a tagname). Follows the normal rules for names.
SampleDescription	string	optional	is a text description of this sample value.
SampleUnit	string	optional	is a description of the unit of messurement for this sample.
SampleGroup	string	optional	designates (in some datasrvs) that all samplepoints in that group should be handled (displayed) together. The DCM system itself places no meaning on this group affiliation.
SamplesSaved	integer > 0	mandatory	is the number of values collected that is saved as minimum in the Store'n'Forward database. If set to 0 the Samplepoint isn't stored in the S'n'F database and thus not delivered to cloud, but can be used for aggregations.
OnlySaveOnChanged	bool	optional	control if new sample values should only be saved to the store-and-forward database if the values have changed since last sample. If not set, it is false.
SampleDataType	string-enum	mandatory	The type of data collected. The possible values are: "bool" (1 bit), "sbyte" (8 bit signed), "byte" (8 bit unsigned), "int16" (16 bit signed), "uint16" (16 bit unsigned), "int32" (32 signed), "uint32" (32 bit unsigned), "int64" (64 bit signed), "uint64" (64 bit unsigned), "float" (32 bit), "double" (64 bit), "string" (variable text up to 24575 bytes. Includes terminating NUL), "data" (variable variable data up to 24575 bytes).
SampleLowerLimit	integer/double	optional	The lower limit for the collected data. If the collected data value is less than SampleLowerLimit it is evaluated inaccordance to SampleLimitDiscard and SampleLimitAlarm.
SampleUpperLimit	integer/double	optional	The upper limit for the collected data. If the collected data value is more than SampleUpperLimit it is evaluated inaccordance to SampleLimitDiscard and SampleLimitAlarm.
SampleLimitDiscard	bool	maybe-optional	Controls if a sample limit violation results in the sample value being discarded. Mandatory if either SampleLowerLimit or SampleUpperLimit is present.
SampleLimitAlarm	bool	maybe-optional	Controls if a sample limit violation generates an alarm. Mandatory if either SampleLowerLimit or SampleUpperLimit is present.
InternalData	Object	maybe-optional	Description of the internal behavior of this sample point. Mandatory if the protocol type is "Internal".

Aggregation

The InternalData object contains the following elements:

Function	Type	Importance	Description
InternalFunction	string-enum	mandatory	This is the internal function to be performed. The currently possible values are: "SystemTemperature" (in centigrades Celcius), "CPULoad" (in percent), "FreeMem" (in kB), "UTCRTC" UTC Real TIme Clock broken into 8 separate values, "DigitalInput" (as 0/1), "IngressRate" (in bytes/s), "EgressRate" (in bytes/s), "DBCachesize" (in bytes), "DBSize" (in bytes), "GSMRssi" (in dBm), "GSMBer" (in percent), "GSMOperator" (text string), "GSMTechnology" (text string: "4G", "3G", "GPRS" etc.).
InternalIndex	integer >= 0	maybe-optional	If InternalFunction is "DigitalInput" this is the mandatory index of the Digital I/O input port to collect value from. If InternalFunction is "UTCRTC" this is the mandatory index of the time: 0 - second (0-59), 1 - minute (0-59), 2 - hour (0-23), 3 - day of the month (1-31), 4 - month (0-11), 5 - Year (-1900), 6 - day of the week (0-6, Sunday = 0), 7 - day in the year (0-365, Jan 1st = 0).
InternalFieldname	string	optional)	Used when the InternalFunction is "IngressRate" as a nameref for the sample to show the ingress rate for or when the InternalFunction is "EgressRate" as the name of a Dataserver to show the egress rate for. If not specified, the rate is the total ingress or egress rate.
InternalSampleInterval	integer >= 0	mandatory	The number of seconds between each sample of this Internal object. If the interval is 0, only eventdriven polling is used.

Aggregation samplepoint for condition monitoring (Eventbased logging)

{
  "CollectorDescription": "SDCM Internal Values Server",
  "CollectorName": "demointernal",
  "Protocol": "Internal",
  "SamplePoints": [
    {
      "SampleDataType": "double",
      "SampleDescription": "CPU load",
      "SampleLimitAlarm": false,
      "SampleLimitDiscard": false,
      "SampleLowerLimit": -1000,
      "SampleName": "CPU",
      "SampleUpperLimit": 1000,
      "SamplesSaved": 3000000,
      "InternalData": {
        "InternalFunction": "CPULoad",
        "InternalSampleInterval": 1
      }
    },
    {
      "SampleDataType": "double",
      "SampleDescription": "FreeMem",
      "SampleLimitAlarm": false,
      "SampleLimitDiscard": false,
      "SampleLowerLimit": -1000,
      "SampleName": "FreeMemory",
      "SampleUpperLimit": 1000,
      "SamplesSaved": 3000000,
      "InternalData": {
        "InternalFunction": "FreeMem",
        "InternalSampleInterval": 1
      }
    },
    {
      "SampleDataType": "double",
      "SampleDescription": "SystemTemperature",
      "SampleLimitAlarm": false,
      "SampleLimitDiscard": false,
      "SampleLowerLimit": -1000,
      "SampleName": "SystemTemperature",
      "SampleUpperLimit": 1000,
      "SamplesSaved": 3000000,
      "InternalData": {
        "InternalFunction": "SystemTemperature",
        "InternalSampleInterval": 1
      }
    }
  ]
}

See complete aggregation examples here:

data collection internalcollector internal data collector dcm json date 20200904

Creation date: 11/12/2019 14:10 (skr@secomea.com) Updated: 04/09/2020 15:59 (tvo@secomea.com)

SiteManager Internal Collector

Prerequisite:

Samplepoint items

Aggregation