This publisher is the most commonly used as it writes data to the statistics table in the Butler database. Data in this table is used as source for widgets in the Dashboard, but it can also be used to collect statistics for later usage.

Before publishing data using the Statistics Writer, a Statistics definition needs to be created from Administrator -> Statistics definitions.

The statistics table is a generic table, similar to CUGEX1 in M3 13.1+. It has multiple key, string, integer, decimal, date and boolean fields. Fields that should be used for the specific statistics data are described in the Statistics definition, with readable names and column display order.

Note: Butler is not intended as a BI tool, but rather live data or short term history monitoring. Storing large amounts of statistics data in Butler will affect performance negatively.

Note: When storing data from a SQL query, use lowercase field names. When storing data from any other collector, use field name with actual case, as it looks in the input file.

Parameters

• Statistics definition – select relevant statistics definition
• Root path root path of data to iterate (blank if data is not in a tree structure)
• Field mapping – when Statistics definition is selected, relevant fields will show and collector data is mapped to the Statistics definition fields

Parameter setup example

Output example