EV Observe - Synthetic Monitoring Module - Database and CSV Files Description

Last modified on 2023/09/28 16:55

The Synthetic Monitoring module uses Agents to collect response times from scenarios played on remote machines to measure user satisfaction. Metrics are stored locally in two CSV files and in a Microsoft database.

Characteristics

Database tables

Note: The database also includes a table called Version, which is used to check the version of the various tables when an update is required.

  • Loops table: Stores metrics for each scenario loop and information about the scenario itself.
  • Agents_Table table: Stores the status of Agent (connected, disconnected, etc.) for monitoring the entire infrastructure running for the Synthetic Monitoring module.

CSV files

  • CSV files are sent from the Agents to the Console over the WCF network.
  • If a database is configured, CSV files are imported for a database update.
  • If no database is specified, CSV files are saved in the Console machine directory (C:\ProgramData\Itexis\Logs\) waiting for further actions.

Notes

  • Microsoft database versions supported: SLQ 2008, 2014, 2016. Express version.

Database description

Loops table

Field Description
LoopID Loop identifier
AgentGroupID Agent's group identifier
AgentName Agent name and computer on which it is installed
ScriptGroupID Scenario's group identifier
ScriptName Scenario name
StringSet Iext input file
NumberOfOperations Number of lines in the script
StartDate Start date of the scenario (in UTC)
TimeBias Time shift of the place where the script was executed
NumberOfLoopsRequested Number of loops requested
CurrentLoopNumber Current loop number
LastLoopDetailID ID of the last LoopDetails record
LastActionNumber Last action number
LastAction Last script action
LastObjectClass Last object class on which the last script action was executed
LastObjectLabel Last object label on which the last script action was executed
LastActionMessage Termination message
PlaybackStatus Final status of script execution
Alarm Alarm yes/no. Even if the script ended successfully, one of the transactions may have triggered an alarm.
TotalReferenceTime Total reference time for the script
PlaybackTime Playback time for the script
OverallDelay Overall delay for the script
OverallDelayPercent Overall delay for the script in percentage (%)
ScreenShot Binary field containing a screenshot at the time of the error
ObjectImageReference Binary field containing a picture which was looked for
ThumbnailReference Binary field containing a thumbnail picture which was looked for if any
ErrorScript Name of the script executed when an error has occured

LoopDetails table

Field Description
LoopDetailID Loop detail identifier
LoopID Loop identifier
TransactionDate Date of transaction (in UTC)
TransactionEndDate End date of transaction (in UTC)
TransactionNumber Transaction number
TransactionName Transaction name
TransactionReferenceTime Reference time for the transaction
TransactionPlaybackTimePlayback Time for the transaction
TransactionDelay Delay for the transaction
TransactionDelayPercent Delay for the transaction in percentage (%)
OverallDelay Cumulated delay from the start of the Loop
OverallDelayPercent Cumulated delay from the start of the Loop in percentage (%)
TransactionPlaybackStatus Status of transaction execution

Agents_Table table

Field Description
Client_ID Machine identifier
Client_Name NetBIOS machine name
Client_Status Machine status (Online / Disconnected)
Schedule_Status Scheduling status when client is disconnected (Scheduled, none)
Agent_Name Scheduled scenario name when client is disconnected
Date_Entry Entry date
DisconnexionTime_MinTime Disconnexion time (in minutes)
AlertMailSent Send an e-mail alert

Tasks_Table table

Field Description
Client_ID Machine identifier
Client_Name NetBIOS machine name
TimeBias Time shift of the place where the script was executed
Task_FileName XML task file name
IsActive Indicates if the task is active (true/false)
Date_Begin Task start date
Date_End Task end date
DaysOfWeek Days of the week when the task is performed
IsLocalTime Use local time or database time (true/false)
WithoutPeriods Periods within the scheduling which are excluded
FrequencyMin Frequency in minutes
Script Scenario name

CSV file description

CSV files for Loops table

Instruction ADD

AgentGroupID As String,
AgentName As String,
UserName As String,
ScriptGroupID As String,
ScriptName As String,
StringSet As String,
TransactionsCount As Integer,
StartDate As DateTime,
TimeBias As Integer,
NumberOfLoopsRequested As Integer,
CurrentLoopNumber As Integer

Instruction UPD

LoopID As Integer,
LastLoopDetailID As Integer,
LastActionNumber As Integer,
LastAction As String,
LastObjectClass As String,
LastObjectLabel As String,
LastActionMessage As String,
LastKeyObject As String,
PlaybackStatus As Integer,
Alarm As Integer,
TotalReferenceTime As Integer,
PlaybackTime As Integer,
OverallDelay As Integer,
OverallDelayPercent As Integer,
ScreenShot As String,
ObjectImageExpected As String,
ObjectImageFound As String,
ErrorScript As String,
SendDBMail As Integer,
EmailTrigger As Integer,
NumAlarms As Integer,
ToField As String,
CcField As String,
BccField As String,
Sender As String,
SenderName As String,
SMPTAddress As String

CSV files for LoopDetails table

Instruction ADD

LoopID As Integer,
TransactionDate As DateTime,
TransactionEndDate As DateTime,
TransactionNumber As Integer,
TransactionName As String,
OverallDelay As Integer (not used),
ByVal OverallDelayPercent As Integer (not used),
TransactionDescription As String

Instruction UPD

LoopDetailID As Integer,
TransactionEndDate As DateTime,
TransactionReferenceTime As Integer,
TransactionPlaybackTime As Integer,
TransactionDelay As Integer,
TransactionDelayPercent As Integer,
OverallDelay As Integer,
OverallDelayPercent As Integer,
TransactionPlaybackStatus As Integer
Tags:
Powered by XWiki © EasyVista 2024