Asset Statistics

Analyzes specific assets of a specific node, single or multiple assets. Display graphically and in a table the download-, metadata updated-, asset version activated- and asset version added- count. The results are also downloadable as an Excel file. Result grouping by day, asset or user or PIN.

Database View

Before installation of the extension, it is necessary to create the view asset_statistic manually by executing the following command on your CELUM database.

MS SQL

CREATE VIEW asset_statistic
    as SELECT stats.IMS_ID, stats.IMS_TIME, stats.IMS_USER_ID, stats.IMS_EVENT_TYPE, stats.IMS_ENTITY_ID, attr.IMS_VALUE_STRING, cast(stats.ims_time as date) as ims_day
    FROM IMS_STATS stats
    LEFT JOIN ims_stats_attributes attr ON (stats.ims_id = attr.ims_stats_id AND attr.ims_attribute = 12)
    WHERE stats.IMS_ENTITY_TYPE = 1

MySQL

CREATE VIEW asset_statistic
    as SELECT stats.IMS_ID, stats.IMS_TIME, stats.IMS_USER_ID, stats.IMS_EVENT_TYPE, stats.IMS_ENTITY_ID, attr.IMS_VALUE_STRING, cast(stats.ims_time as date) as ims_day
    FROM IMS_STATS stats
    LEFT JOIN ims_stats_attributes attr ON (stats.ims_id = attr.ims_stats_id AND attr.ims_attribute = 12)
    WHERE stats.IMS_ENTITY_TYPE = 1

Oracle

CREATE VIEW <DB_USER>.asset_statistic
    as SELECT stats.IMS_ID, stats.IMS_TIME, stats.IMS_USER_ID, stats.IMS_EVENT_TYPE, stats.IMS_ENTITY_ID, attr.IMS_VALUE_STRING, cast(stats.ims_time as date) as ims_day
    FROM <DB_USER>.IMS_STATS stats
    LEFT JOIN <DB_USER>.ims_stats_attributes attr ON (stats.ims_id = attr.ims_stats_id AND attr.ims_attribute = 12)
    WHERE stats.IMS_ENTITY_TYPE = 1

It is also recommended to execute the following command once in order to correct inconsistent statistic entries:

UPDATE IMS_STATS SET IMS_USER_ID = 0 where IMS_USER_ID IS NULL

Properties

To be configured in {home}/appserver/conf/custom.properties

assetStatistic.visibleForGroup

type: long, required: no, default: -

restrict the use of the plugin to this user group ID (superadmins always see it in any case)

GUI Properties

assetStatistic.color.slider.range

type: Hex Color Code, required: no, default: #086aa6

Color of the selected slider range

assetStatistic.color.slider.background

type: Hex Color Code, required: no, default: #9CC3DB

Color of the slider background

assetStatistic.color.slider.fontSelected

type: Hex Color Code, required: no, default: #074E82

Font color of the slider selection

assetStatistic.color.countGraph.bars.background

type: Hex Color Code, required: no, default: #454d7d

Color of the bars in the graphics

assetStatistic.color.countGraph.bars.border

type: Hex Color Code, required: no, default: #086AA6

Color of the bar borders in the graphics

Screenshots

Asset Statistic no grouping

Asset Statistic group by days

Asset Statistic group by PIN Download

Asset Statistic group by users

Asset Statistic group by assets