Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Question Informations about log tables

More
29 Sep 2021 13:53 - 29 Sep 2021 13:57 #1 by Aymeric_Synergy
Informations about log tables was created by Aymeric_Synergy
English version :

Hello,

I would like to have detailled information about the following Sambia's log tables :
STB_LOG_ACTION_ACT
STB_LOG_ACTION_ALTID_AAI
STB_LOG_ACTION_PROP_ACP
STB_LOG_ACTION_SPROP_ASP
STB_LOG_ACTION_STAT_AST
STB_LOG_ACTION_S_ACT
STB_LOG_DELIVERY_DLV
STB_LOG_LINK_LNK
STB_LOG_PROCESS_STAT_PST
STB_LOG_SESSION_CHILDS_CSES
STB_LOG_SESSION_SESS
STB_LOG_SESSION_STAT_SST
STB_LOG_USER_ACTION_LOG_UAL
STB_LOG_VERSION_HIST_VHS
STB_LOG_VERSION_V

I cannot find any information about any of these tables on the Internet. I want to have the following information:
1)Description of the tables
2)Detailled information about each fields present in the tables
3)Relationship about each tables (for example their primary keys/Foreign keys...)
4)Any additional information which would help me to understand the structure of these tables

My goal is to create a dashboard in order to analyse the duration of each processes or sub-processes to highlight the performance of executions.

Thanking you in advance for your help.

Best regards.


Version française :

Bonjour,

J'aurais souhaité avoir des informations détaillées au sujet des tables de log Stambia suivantes :
STB_LOG_ACTION_ACT
STB_LOG_ACTION_ALTID_AAI
STB_LOG_ACTION_PROP_ACP
STB_LOG_ACTION_SPROP_ASP
STB_LOG_ACTION_STAT_AST
STB_LOG_ACTION_S_ACT
STB_LOG_DELIVERY_DLV
STB_LOG_LINK_LNK
STB_LOG_PROCESS_STAT_PST
STB_LOG_SESSION_CHILDS_CSES
STB_LOG_SESSION_SESS
STB_LOG_SESSION_STAT_SST
STB_LOG_USER_ACTION_LOG_UAL
STB_LOG_VERSION_HIST_VHS
STB_LOG_VERSION_V

Je ne trouve d'information nulle part sur internet. Je voudrais les informations suivantes :
1)Description des tables
2)Informations détaillées sur chacun des champs
3)Liens entre les tables (par exemple les clés primaires, clés étrangères...)
4)Toute information qui pourrait me permettre de comprendre la structure de ces tables

Mon objectif est de créer un tableau de bord permettant analyser l'évolution des durées de chaque processus et sous-processus dans le temps afin de mettre en évidence les performances des exécutions.

Par avance, merci pour votre aide.
Last edit: 29 Sep 2021 13:57 by Aymeric_Synergy.