====== AnalyzePromoteMessages ======
Copies messages with the most important information to any database table. These you can use to create analytic reports. For more details see  [[en:ueberblick:ebiss_module:analytics:dataanalytics:start|]],

^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):
<code>
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))

</code>