Sidebar
en:prozessdefinition:jobs:jobsteps:analytics:analyzepromotemessages
AnalyzePromoteMessages
Copies messages with the most important information to any database table. These you can use to create analytic reports. For more details see Data Analytics,
| GENERATED src=“eBiss.Analytics.Resources.JobSteps.AnalyzePromoteMessages” changed=““ | |
|---|---|
| Properties | |
| Name | Description |
| Type | Class name of the jobstep |
| Name | Name for the jobstep that will appears in the job designer |
| Description | Optional description for the jobstep |
| Runs | Sets how many times messages will be collected per job run. |
| Number of messages | Sets how many messages will be prcessed. |
| DB Connection | The DB connection string to target database. If not set, the current eBiss DB will be used. It can be read from the eBiss.Service.exe.config and is for example: “server=[SERVER];database=[DB_NAME];Integrated Security=True;”\\You can use a variable of the default system partner by “${<variable name>}“ |
| Database adapter | The adapter to connect to the DB, e.g. “Pranke.Orm.DbAdapter.MsSql”. If not set, the current eBiss DB adapter will be used. You can select all DBs supported by eBiss, e.g.: MS-SQL-Server, MySQL, PostgreSQL, etc. The value for the adapter can be read from eBiss.Service.exe.config. \\You can use a variable of the default system partner by “${<variable name>}“ |
| Start date | Sets the start date to copy messages until now. Maximum amount of messges per job run is 1000 |
The table structur of the target tables (state 18.10.2018):
CREATE TABLE PrankeMessageAnalytics ( Oid uniqueidentifier NOT NULL, NodeName nvarchar(256), Subject nvarchar(256), ComAddressType smallint, EntryDate datetime, LastRunDate datetime, Size BIGINT, OwnLocationName varchar(64), PartnerName varchar(64), Direction smallint NOT NULL, TransferDate datetime, Runs smallint, -- Message runs, depending on the manuel or job runs, e.g. restart by Changes smallint, -- Number of changes CONSTRAINT PKEY_PrankeMessageAnalytics_Oid PRIMARY KEY (Oid)) CREATE TABLE PrankeDocumentAnalytics ( Oid uniqueidentifier NOT NULL, Message_oid uniqueidentifier NOT NULL, DocType varchar(64), DocSubType varchar(64), DocNumber varchar(64), DocDate varchar(64), CONSTRAINT PKEY_PrankeDocumentAnalytics_Oid PRIMARY KEY (Oid)) CREATE TABLE PrankeTaskAnalytics ( Oid uniqueidentifier NOT NULL, Message_oid uniqueidentifier NOT NULL, CreationDate datetime, TaskMessage smallint, Info text, CONSTRAINT PKEY_PrankeTaskAnalytics_Oid PRIMARY KEY (Oid)) CREATE TABLE PrankeAnalyticsSettings ( KeyEntry varchar(64), ValueEntry varchar(1024), CONSTRAINT PKEY_PrankeAnalyticsSettings_Oid PRIMARY KEY (KeyEntry)) CREATE TABLE PrankeAnalyticsSchemaVersion ( Name varchar(64) NOT NULL, Version varchar(64), LastUpgrade datetime, CONSTRAINT PKEY_PrankeAnalyticsSchemaVersion_Id PRIMARY KEY (Name))
en/prozessdefinition/jobs/jobsteps/analytics/analyzepromotemessages.txt · Last modified: 2024/02/20 08:15 by 127.0.0.1