Skip to main content
Version: 2023.3

ElastiCube Tables

This article describes, for reference purposes, each of the component tables in the ElastiCube data store. The dashboards that present information for your analysis compiles its information from the ElastiCube data store.

note

In 2021.2 we added several tables for enhanced searchability and filtering. These tables are not documented in this article but are included in ElastiCube.

App daily log

(Used in Legacy dashboards) The App daily log provides daily information of App utilization. Each row in the table represents a day in which a deployed App was active, and includes the resource ID of the deployed App.

NameTypeDescription
DateIdIntegerAn integer representation of the date and time
DateDate-TimeThe date and time
ResourceIdTextThe unique identifier of the deployed App resource

Calendar

The ElastiCube Calendar component table provides date and time at which any items in the inventory were used.

NameTypeDescription
DateDate-TimeThe date and time
DateIdIntegerAn integer representation of the date and time
TimePeriodIntegerThe reservation's duration. Options are 1 / 7 / 30 / 365 (days).

Executions

(Used in Legacy dashboards) The ElastiCube Executions table provides details of tests that were executed from CloudShell’s job scheduling module and that had logging profile of "All”.

NameTypeDescription
BatchNumberTextThe batch number that the user entered, in case the execution was triggered from the Runner
CalculatedTestResultTextTerminated, Error, Passed, Failed, Completed
DayIntegerThe day of month in which the execution started
EndTimeTimeStampTextA text representation of the execution end time
ExecutionEndTimeDate-TimeThe date and time at which the execution ended
ExecutionErroredInteger1-The execution ended with error, 0-otherwise
ExecutionFailedInteger1-The test had failed, 0-otherwise
ExecutionIdTextThe unique identifier of the execution
ExecutionNameTextThe name of the execution (also represents the name of the test)
ExecutionPassedInteger1-The test passed, 0-otherwise
ExecutionPathTextThe full path to the test, for example: TestShell/Tests/Shared/Test 1
ExecutionResultsTextTerminated, Error, Passed, Failed, Completed
ExecutionStartTimeDate-TimeThe date and time at which the execution started
ExecutionTerminatedInteger1-The execution terminated, 0-otherwise
IsRegressionInteger1-regression, 0-standard test
JobExecutionIdTextForeign key to JobExecutionHistory table
MonthIntegerThe month in which the Execution started
PartNumberTextThe part number that the user entered, in case the execution was triggered from the Runner
QuarterIntegerThe quarter in which the Execution started
RegressionResultIdTextThe unique identifier of the result
ResultCodeInteger0-Fail, 1-Pass, Empty-None
ResultStringTextPass, Fail, None
RootExecutionIdTextThe unique identifier of the root test that initiated the execution (used for nested tests)
SerialNumberTextThe serial number that the user entered, in case the execution was triggered from the Runner
StartTimeTimeStampTextA text representation of the execution start time
StationNameTextThe name of the station that triggered the execution
StatusCodeInteger1-Completed, 2-Terminated, 0-Running
StatusStringTextCompleted, Terminated, Running
TestIdTextThe unique identifier of the execution test
User IdTextThe unique identifier of the user who initiated the execution
UserNameTextThe user name of the user who initiated the execution
UUTIdTextThe unique identifier of the UUT that was linked to the execution
UUTNameTextThe name of the UUT that was linked to the execution
UUTPathTextThe path of the UUT that was linked to the execution
VersionTextThe version that the user entered, in case the execution was triggered from the Runner
YearIntegerThe year in which the Execution started

Job execution history

(Used in Legacy dashboards) The Job execution history table uses the parameters listed below:

NameTypeDescription
JobIdTextThe unique identifier of the job
JobNameTextThe name of the job
SuiteExecutionIdTextThe unique identifier of the automation suite's execution (Foreign key to the suite execution history table)
SelectedExecution ServerTextThe execution server that was selected to run the job.
JobResultTextCompleted, Passed, Failed, Ended With Error, Ended With An Exception, Manually Stopped, Terminated, or Not Started
CreateTimeDate-TimeThe date and time at which the job was created
EnqueueTimeDate-TimeThe date and time at which the job was enqueued
ScheduledTimeDate-TimeThe date and time at which the job was scheduled to run
ActualStart TimeDate-TimeThe date and time at which the job started running.
ActualEndTimeDate-TimeThe date and time at which the job stopped running
Logging ProfileTextThe selected logging profile for this job’s tests. None, All, Results, Measurements and Results
Stop On FailIntegerIndicates whether to stop the job execution if one of the tests fails.
Stop On ErrorIntegerIndicates whether to abort the job if any test ends with an error.
TopologyIDTextThe unique identifier of the blueprint
ReservationIDTextThe unique identifier of the sandbox
EstimatedJobDurationDecimalThe estimated duration of the job's execution
JobTopologyTextThe blueprint that was requested for the job
JobDurationIntegerThe actual job duration in seconds

Login data log

(Used in new dashboards) The Login data log enables users to filter the dashboards according to user login time.

NameTypeDescription
ActionTypeTextIndicates the login type. Options are:
  • Login: Regular login
  • SSOLogin: Login via SSO
TimeDate-TimeThe date and time at which the user logged into CloudShell
UserIdTextThe user who logged in to CloudShell
DomainIdTextID to which the user logged in
ClientTypeTextType of client used to log in. Options are: Unknown, API, Portal, WpfClient and JSS

Measurements only

(Used in Legacy dashboards) As part of test development, you can specify one or more measurements for each test. As part of the test execution, you can provide values for these measurements. The test attributes and measurements values logged during test execution are listed in the database using the fields below.

NameTypeDescription
DayIntegerThe measurement's start time – day
ExecutionIdTextFK to executions table
MeasureDimensionTextThe dimension of the measure: Scalar, Vector, Matrix
MeasurementEndTimeDate-TimeThe date and time at which the measurement ended
MeasurementFailedInteger1 – Failed, 0 – Otherwise
MeasurementNameTextThe name of the measurement
MeasurementPassedInteger1 – Passed, 0 – Otherwise
MeasurementPathTextThe path to the measurement
MeasurementResultCodeIntegerThe result of the measurement: 1-Passed, 0-Failed, else - None
MeasurementResultStringTextText representation of the measurement result
MeasurementStartTimeDate-TimeThe date and time at which the measurement started
MeasurementTypeTextThe type of measurement: Numeric, String, Image
MonthIntegerMeasurement start time – month
QuarterIntegerMeasurement start time – quarter
ResultCodeInteger1-Pass, 0-Fail, Empty – None
ResultStringTextText representation of the result
StatusCodeInteger3-Completed, 1-Terminated, 4-NotStarted, None, 2-Started, 7-Debugged, 5-Error, 0-Skipped
StatusStringTextCompleted, Terminated, NotStarted, None, Started, Debugged, Error, Skipped
StepIdTextThe unique identifier of the step in the test
StepNameTextThe name of the step as defined in the test
StepTypeTextThe type of step, for example: Text To Report, Fail, Pass
ValueNumericInteger(Relevant for numeric measurements) Numeric representation of the value
ValueStringTextString representation of the measurement value
VariableTextThe variable's name
YearIntegerThe measurement's start time - year
CalculatedMeasurementResultTextPassed, Failed

Reservation daily log

The Reservation daily log table provides daily information of blueprint utilization.

Each row in the Reservation daily log table represents a single sandbox that was active in a specific day. Calendar days that have no sandboxes do not appear in this log.

NameTypeDescription
DateDate-TimeThe record date (one of the dates in which the sandbox was active)
DateIdTextInteger representation of the date
ExtendedEndDateDate-Time(Used in legacy dashboards) If the sandbox was extended, this field displays the extended date.
JobIdText(Used in legacy dashboards) The unique identifier of the automation suite job that created the sandbox
ActualEndDateDate-TimeThe exact date and time at which the sandbox ended
PlannedEndDateDate-TimeThe planned end date for the sandbox according to the value specified during sandbox creation
ReservationCountInteger(Used in legacy dashboards) The number of concurrent sandboxes in CloudShell when this sandbox was created
StartDateDate-TimeThe date and time at which the sandbox started
StartDateIdInteger(Used in new dashboards) Integer that indicates the date in which the sandbox started. Format: |YEAR| |MONTH| |DAY|. For example: "20210720" indicates "7/20/2021”
DailyDurationIntegerDaily sandbox duration (in minutes)
DailyDuration_daysInteger(Used in new dashboards) Daily sandbox duration (in days)
TotalDurationInteger(Used in legacy dashboards) Total sandbox duration (in minutes)
ReservationIdTextThe unique identifier of the sandbox
ReservationNameTextThe name of the sandbox
ReservingDomainText(Used in legacy dashboards) The domain in which the sandbox was created
ReservedTopologyTextThe name of the reserved blueprint
TopologyIdTextThe unique identifier of the blueprint that was reserved
OwnerNameTextThe name of the sandbox owner
UserIdText(Used in new dashboards) The unique identifier of the user. Used for improving query performance.
EndDateDate-TimeThe estimated end date of the sandbox, or the actual end date in case the sandbox already ended

Reservation rejection log

(Used in new dashboards) The Reservation rejection log table lists each rejected reservation request and the rejection reason.

Each row in the Reservation summary log table represents a single reservation rejection. Calendar days that have no rejected reservations do not appear in this log.

NameTypeDescription
ReservationIdTextThe unique identifier of the sandbox
BlueprintIdTextThe unique identifier of the blueprint from which the reservation was launched
BlueprintNameTextName of the blueprint from which the reservation was launched
SavedSandboxIdTextThe unique identifier of the saved sandbox from which the reservation was launched
StartTimeDate-TimeThe date and time at which the sandbox started
EndTimeDate-TimeThe date and time at which the sandbox ended
OwnerLongIdTextInternal owner ID to be used when OwnerId cannot be resolved.
DomainIdTextThe unique identifier of the domain in which the reservation was launched
RequestTimeDate-TimeThe date and time at which the reservation was requested
RejectReasonTextReason for rejecting the reservation.
Reasons include:
  • resource conflict
  • license limit global
  • license limit domain (pool)
  • user limitation - # of concurrent sandboxes
  • user limitation - sandbox length
  • no solution
RequestTypeTextType of reservation request. Options are New and Reschedule
IsRecurrenceBoolTrue if reservation is part of a series

Reservation setup log

(Used in new dashboards) The Reservation setup log indicates which reservations successfully completed setup.

NameTypeDescription
ReservationIdTextThe unique identifier of the sandbox
SetupStartTimeDate-TimeThe date and time at which the sandbox's setup process started
IsSuccessBoolTrue if reservation setup completed successfully

Reservation summary log

The Reservation summary log table provides details about the completed, running, and pending sandboxes in CloudShell.

Each row in the Reservation summary log table represents a single sandbox. Calendar days that have no sandboxes do not appear in this log.

NameTypeDescription
IdIntegerThe unique identifier of the reservation event.
ActualEndDateDate-TimeThe exact date and time at which the sandbox ended
DomainIdTextThe unique identifier of the domain in which the sandbox was created
DomainNameTextThe name of the domain in which the sandbox was created
ExtendedEndDateDate-TimeIf the sandbox was extended, this field displays the extended date.
AbuseText(Used in legacy dashboards) Indicates a resource in the reservation that is not utilized by drivers.
JobIdText(Relevant for sandboxes created by automation suite jobs) The unique identifier of the job
PlannedEndDateDate-TimeThe planned sandbox end date that was defined when creating the sandbox
TypeIntegerType of blueprint used. Options are: Regular, View and Template.
ReservationCountIntegerThe number of concurrent sandboxes in CloudShell when this sandbox was created
StartDateDate-TimeThe date and time at which the sandbox was started
StartDateIdIntegerThe unique identifier of the sandbox's start date. Format: |YEAR| |MONTH| |DAY|. For example: "20210720" indicates "7/20/2021”
OvertimeMinutesInteger(Relevant for sandboxes that went into overtime) The sandbox's overtime duration in minutes
DurationIntegerTotal sandbox duration (in minutes)
ReservationIdTextThe unique identifier of the sandbox
ReservationNameTextThe name of the sandbox
ReservingDomainText(Used in legacy dashboards) The domain in which the sandbox was created
ReservedTopologyTextThe name of the reserved blueprint
TopologyIdTextThe unique identifier of the blueprint that was reserved
UserIdTextThe unique identifier of the user. Used for improving query performance.
SavedSandboxIdTextThe unique identifier of the saved sandbox from which the reservation was launched
OwnerNameTextThe name of the sandbox owner
EndDateIdIntegerUnique identifier of the sandbox's end date. Format: |YEAR| |MONTH| |DAY|. For example: "20210720" indicates "7/20/2021”
EndDateDate-TimeThe estimated end date of the sandbox, of the actual end date in case the sandbox had already ended

Resource attributes value summary

(Used in Legacy dashboards) The Resource attributes value summary table provides information about all the resources in CloudShell.

Each record in this table represents a single resource in CloudShell. For each attribute that has the Displayed in Insight rule, a column is added to the table. This table is updated once a day. For more information, see Displaying attributes in BI.

NameTypeDescription
ResourceIdTextThe unique identifier of the resource

Resource attributes log

(Used in Legacy dashboards) The Resource attributes log table lists all the attributes that have the Displayed in Insight rule.

NameTypeDescription
AttributeNameTextThe name of the attribute
AttributeTypeTextThe attribute's type (string, password, numeric, boolean, or lookup)
IdIntegerThe unique identifier of the attribute

Resource attribute value log

(Used in Legacy dashboards) The Resource attribute value log table provides the values of all the attributes that have the Displayed in Insight rule.

NameTypeDescription
AttributeIdIntegerThe unique identifier of the attribute
AttributeValueTextThe value of the attribute
ResourceIdTextThe unique identifier of the resource

Resource family log

(Used in Legacy dashboards) The Resource family log table lists the name and unique ID of each resource family in CloudShell, as well as whether it is connectable.

NameTypeDescription
IdBig IntegerThe unique identifier of the family
IsConnectableTextIndicates whether a resource family is defined to be connectable (for example: ports, NICs and so on.)
ResourceFamilyNameTextThe name of the family

Resource log

This Resource log table lists the resources in the inventory. Each resource is associated to a model. Each model can be associated with one or more resources. A resource can have a hierarchy, or be part of a hierarchy.

The Resource log table provides all the levels of the hierarchy. Each resource has two hierarchy connections: a connection to its parent resource, if one exists. and a connection to the root resource - the resource in the highest level of the hierarchy, if one exists.

Legacy dashboards:

NameTypeDescription
root_1IntegerIndicates a root resource
Leaf_1IntegerIndicates an edge sub-resource. For example, port.
CreatedDate-Time(Used in old dashboards) The time at which the resource was created
DateidIntegerUnique identifier of the resource's creation date. Format: |YEAR| |MONTH| |DAY|. For example: "20210720" indicates "7/20/2021”
CalculatedResourceModelText(Used in old dashboards) By default the value is the CloudShell Model name. If the resource has a Model attribute, this field contains the attribute value.
Calculated RootModelText(Used in old dashboards) By default the value is the CloudShell Model name. If the resource has a Model attribute, this field contains the attribute value.
DeletedDate-Time(Used in old dashboards) The time at which the resource was deleted
IdTextThe unique identifier of the resource
ParentIdTextThe unique identifier of the parent resource
ResourceFullNameText(Used in old dashboards) The full name of the resource. The full name contains the resource name and the hierarchy.
For example: Switch 1\Blade 2\Port 34
ResourceModelIdBig Integer(Used in old dashboards) The unique identifier of the model
ResourceNameTextThe name of the resource
RootIdTextThe unique identifier of the root resource that contains the resource.
For example: the identifier of "Switch 1” in the following port "Switch 1\Blade 2\Port 34”
Note that for root resources the value is the resource's unique identifier.
RootNameTextThe name of the root resource that contains this resource.
For example: the value of "Switch 1” in the following port "Switch 1\Blade 2\Port 34”
Note that for root resources the value is the resource's name.
ParentNameText(Used in old dashboards) The unique identifier of the parent resource.
For example: the identifier of "Blade 2” in the following port: "Switch 1\Blade 2\Port 34”
Note that for root resources the value is empty because they do not have a parent.
RootFamilyNameTextThe family name of the root resource
RootModelNameTextThe model name of the root resource
ResourceFamilyName (Used in new dashboards) Family of the resource
ResourceModelName (Used in new dashboards) Model of the resource
IsConnectableTextThis value specifies whether the resource can be connected to other resources
ParentPathTextThe path of the parent resource from the root.
For example: the value for the port "Switch 1\Blade 2\Port 34” is "Switch 1\Blade 2”.
Note that for root resources the value is empty.
BladePathText(Used in old dashboards) (Relevant for connectable resources only) The parent path of the parent resource
AppTemplateNameText(Used in old dashboards) The name of the App template on which the App is based
CloudProviderNameText(Used in old dashboards) The name of the cloud provider resource on which the App is hosted
CreatedInReservationNameText(Used in old dashboards) The name of the sandbox in which the resource or App was created
CreatedInDomainText(Used in old dashboards) The name of the domain in which the App was deployed
RootDeletedDate-TimeThe time at which the root resource was deleted
root_deleted_txtText(Used in new dashboards) If the root of the resource is deleted, the value is "Deleted”. Otherwise null.
root_createdDate-Time(Used in new dashboards) Data and time at which the root resource was created.
resource_createdDate-Time(Used in new dashboards) Date and time at which the resource was created.
resource_deletedDate-Time(Used in new dashboards) Date and time at which the resource was deleted.
resource_deleted_txtText(Used in new dashboards) If the resource is deleted, the value is "Deleted”. Otherwise null.

Resource model log

(Used in Legacy dashboards) The Resource model log table lists the name, unique ID and family of each resource model in CloudShell.

NameTypeDescription
IdBig IntegerThe unique identifier of the model
ResourceFamilyIdBig IntegerThe unique identifier of the family
ResourceModelNameTextThe name of the model

Resource utilization log

The Resource utilization log table provides a daily usage summary of connectable resources in sandboxes.

note

Connectable resources are basically ports that can be connected to other components, such ethernet, fiber, or other connectable ports.

NameTypeDescription
EntryDateDate-TimeThe date of entry that this log record represents (specific day within a sandbox)
IdBig IntegerThe unique identifier of each record
Lock1Integer(Used in legacy dashboards) Daily lock status log, the day is divided into 6 segments, each value can be either 0 or 1:
0 = The resource was not locked in the sandbox in this segment
1 = The resource was locked in the sandbox in this segment
Lock2Integer(Used in legacy dashboards) 4 hour day intervals for resources marked "in use” in the sandbox
Lock3Integer(Used in legacy dashboards) 4 hour day intervals for resources marked "in use” in the sandbox
Lock4Integer(Used in legacy dashboards) 4 hour day intervals for resources marked "in use” in the sandbox
Lock5Integer(Used in legacy dashboards) 4 hour day intervals for resources marked "in use” in the sandbox
Lock6Integer(Used in legacy dashboards) 4 hour day intervals for resources marked "in use” in the sandbox
Res1IntegerDaily sandbox status log, the day is divided into 6 segments, each value can be either 0 or 1:
0 = The resource was not reserved in the sandbox in this segment
1 = The resource was reserved in the sandbox in this segment
Res2Integer4 hour day intervals for resources in a sandbox
Res3Integer4 hour day intervals for resources in a sandbox
Res4Integer4 hour day intervals for resources in a sandbox
Res5Integer4 hour day intervals for resources in a sandbox
Res6Integer4 hour day intervals for resources in a sandbox
ReservationIdTextThe unique identifier of the sandbox
ResourceIdTextThe unique identifier of the resource
TopologyIdTextThe unique identifier of the blueprint
TopologyNameTextName of the blueprint
UserIdTextThe unique identifier of the user who reserved the resource
UsernameText(Used in legacy dashboards) The internal system name of the user who reserved the resource (full name should be retrieved from ReservationSummaryLog table)
EntryDateTimeStampTextTextual representation of the entry date
DayOfWeekText(Used in legacy dashboards) The day of week of the record

The following two examples are presented to show how parameters in the tables are populated with information and how the information can be used to analyze results. These examples use data collected by the Resource utilization log tables.

Example #1

This example shows the utilization information collected for resource ‘Port_12’ during the date 29-Jul-2013:

Date00:00.000:00.000:00.0
ResourceId{Port12}{Port12}{Port12}
TopologyNameDemoLab1DemoLab1DemoLab2
ReservationId{Res1ID}{Res2ID}{Res3ID}
Res1100
Res2100
Res3100
Res4010
ResEntry5000
Res6001
UsernameUser1User1User2

The first two records show that ‘User1’ reserved the resource twice. These sandboxes occurred at different times of the day.

A day is divided into six segments. The value ‘1’ implies that the resource was reserved in segment 1 of the selected day. The port was therefore reserved for ‘User1’ in two different sandboxes for 4/6 parts of the day:

Res
1
Res
2
Res
3
Res
4
Res
5
Res
6
111000
000100

The total utilization of ‘Port 12’ during the date 29-Jul-2013 should take into account all the sandboxes, so it will result in 5/6 parts of the day:

Res
1
Res
2
Res
3
Res
4
Res
5
Res
6
111000
000100
000001

Example #2

This example shows information that was collected and shows the utilization of a chassis that includes ports: ‘Port_12’ and ‘Port 13’ during the date 29-Jul-2013.

The information listed below shows that the first two records belong to ‘Port 12’ and the third record belongs to ‘Port 13’.

EntryDate00:00.000:00.000:00.0
ResourceId{Port12}{Port12}{Port13}
TopologyNameDemoLab1DemoLab1DemoLab2
ReservationId{Res1ID}{Res2ID}{Res3ID}
Res1100
Res2100
Res3100
Res4010
Res5000
Res6001
UsernameUser1User1User2

Each port has a different utilization result:

ResourceIdRes1Res2Res3Res4Res5Res6
{Port12}111000
{Port12}000100
{Port13}000001

Port 12 was utilized for 4/6 of the day while Port 13 was utilized for 1/6 of the day.

However, when summarizing the utilization for the chassis as a resource, you need to join the utilization of the two ports: so the utilization for the chassis for 29-Jul-2013 is 5/6:

Res1Res2Res3Res4Res5Res6
111101

Suite execution history

(Used in Legacy dashboards) The Suite execution history table provides an execution summary of the automation suites in CloudShell.

NameTypeDescription
SuiteIdTextThe unique identifier of the automation suite template
SuiteNameTextThe name of the automation suite template
SuiteExecutionIdTextThe unique identifier of the automation suite's execution
SuiteExecutionNameTextThe name of the automation suite execution
SuiteResultTextThe automation suite 's result
CreateTimeDate-TimeThe date and time at which the automation suite was created
PendingTimeDate-TimeIndicates the date and time at which the automation suite was added to the queue
StartTimeDate-TimeThe date and time at which the automation suite began execution
EndTimeDate-TimeThe date and time at which the automation suite completed its execution
TypeTextTestShell or custom type name
ExecutingUserIdTextThe user who executed the automation suite
OwnerIdTextThe user who is the owner of the automation suite
DomainIdTextThe unique identifier of the domain in which the automation suite was created
SuiteDurationIntegerThe duration of the automation suite
ExecutingDomainTextThe domain that executed the automation suite
UserIdTextThe unique identifier of the user who executed the automation suite

TestShell domain log

(Used in Legacy dashboards) The TestShell domain log provides details about all user domains in CloudShell.

NameTypeDescription
IdTextThe unique identifier of the domain
NameTextThe name of the domain

Topology log

This table provides details about all the blueprints which were available in CloudShell.

The values of this table use the parameters listed below:

NameTypeDescription
CreateDateDate-TimeThe date when the blueprint was created
DeleteDateDate-TimeThe date when the blueprint was deleted
OwnerTextLink to the owner of the blueprint
IDTextThe unique identifier of the blueprint
NameTextThe name of the blueprint
TypeTextRegular / View

User domain

The User domain table indicate a connection between user, group and Domain. A new feature in the ElastiCube is permission-based access – a user should see only their own domain’s data, so this table is needed to query data based on the user’s domain.

NameTypeDescription
EmailTextUser's email
UsernameTextCloudShell user name
DomainIdTextThe unique identifier of the domain
IdTextUnique identifier of the user
NameTextName of the domain
GroupIdTextUser's group associated to the domain

User group

(Used in Legacy dashboards) The groups that are defined in CloudShell and their relation to users.

The User group table provides a way to filter the BI tables by Group.

NameTypeDescription
UserIdTextThe unique identifier of the user
GroupIdTextThe unique identifier of the group
GroupNameTextThe name of the group