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. Because MS SQL has a limit of 2100 parameters per query, For MS SQL Databass the number of assets in one query is limited to 2090. The limit is also configurable.

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.

If you update from a version below 1.4.0 to 1.4.0 or above, you have to delete old view and create it new, because of changes in the columns.

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, stats.IMS_CONTEXT
     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, stats.IMS_CONTEXT
     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, stats.IMS_CONTEXT
    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

The performance can be increased by creating indexes:
CREATE INDEX assetstatistics_index_stats ON ims_stats (ims_time, ims_event_type, ims_entity_id);
CREATE INDEX assetstatistics_index_stats_id ON ims_stats (ims_id);
CREATE INDEX assetstatistics_index_stats_user ON ims_stats (ims_user_id);
CREATE INDEX assetstatistics_index_stats_attributes ON ims_stats_attributes (ims_stats_id, ims_attribute);

Properties

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

assetStatistic.license

type: String, required: yes, default: -

license key (delivered by brix IT Solutions)

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)

assetStatistic.maxAssets

type: number, required: no, default: 2090 (only for MS SQL databases)

Limits the number of assets that can be processed in one query (needed if the database has a query parameter limit).

assetStatistic.anonymousMode

type: boolean, required: no, default: false

Activates the anonymous mode: shows user IDs instead of usernames

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

Compatibility Matrix

Release Notes

1.0

Released 2016-05-19

• Initial Version

1.1

Released 2017-10-19

• PIN-Download statistic added
• Oracle DB compatibility
• GUI optimizations

1.2.0

Released 2017-10-19

• CSS improvements

1.2.1

Released 2018-07-18

• Show anura download reasons in statistic

1.2.2

Released 2019-01-28

• Fixed license check

1.2.7

Released 2020-03-26

• Bugfix when CELUM URL not default (e.g. /appserver)
• Tested with CELUM 6.4

1.3.0

Released 2019-04-02

• Asset limit configurable

1.4.0

Released 2020-10-20

• Filter download type feature

2.0.0

Released 2021-07-20

• Improve loading behavior (async)
• Date range now tunable through individual date fields

2.1.0

Released 2021-08-19

• Added "top 100" feature (Admin menu)

2.5.0

Released 2022-06-16

• Anonymoud mode added (show user IDs instead of usernames)

© brix IT Solutions