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.
Before installation of the extension, it is necessary to create the view asset_statistic manually by executing the following command on your CELUM database.
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
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
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
To be configured in {home}/appserver/conf/custom.properties
type: String, required: yes, default: -
license key (delivered by brix cross media)
type: long, required: no, default: -
restrict the use of the plugin to this user group ID (superadmins always see it in any case)
type: Hex Color Code, required: no, default: #086aa6
Color of the selected slider range
type: Hex Color Code, required: no, default: #9CC3DB
Color of the slider background
type: Hex Color Code, required: no, default: #074E82
Font color of the slider selection
type: Hex Color Code, required: no, default: #454d7d
Color of the bars in the graphics
type: Hex Color Code, required: no, default: #086AA6
Color of the bar borders in the graphics
Released 2016-05-19
- Initial Version
Released 2017-10-19
- PIN-Download statistic added
- Oracle DB compatibility
- GUI optimizations
Released 2017-10-19
- CSS improvements
Released 2018-07-18
- Show anura download reasons in statistic
Released 2019-01-28
- Fixed license check
© brix cross media