SQL Queries - CAST Knowledge Base - Queries on Siebel technology - discrimination time

Purpose of Query

This query returns the history of different discrimination steps as well as the consumption time.

Applicable CAST Version

Release	Yes/No
8.3.x
8.2.x

Applicable RDBMS

RDBMS	Yes/No
CSS4
CSS3
CSS2

Query for CSS

select * 
from siebel_log 
order by 2 asc

Query result example

"Update metrics: start";"2020-11-05 15:13:53.623827"
"Update metrics: end";"2020-11-05 15:14:06.430759"
"Discrimination data - Start";"2020-11-05 15:14:25.658619"
"Discrimination data - LastUpdatedBy";"2020-11-05 15:14:25.662885"
"Discrimination data - Checksum";"2020-11-05 15:14:34.4924"
"Discrimination data - Objects";"2020-11-05 15:14:35.125382"
"Discrimination data - Field props";"2020-11-05 15:15:07.997835"
"Discrimination data - Statistics";"2020-11-05 15:15:10.875434"
"Discrimination data - End";"2020-11-05 15:15:10.877648"
"Discrimination - Start";"2020-11-05 15:15:34.362163"
"Discrimination - End";"2020-11-05 17:33:50.590463"
"DiscriminationEnd - Start";"2020-11-05 17:33:50.592742"
"DiscriminationEnd - End";"2020-11-05 17:35:11.035854"
"Discrimination - Exception FieldProp - Start";"2020-11-05 17:35:11.036152"
"Discrimination - Exception FieldProp - FieldType";"2020-11-05 17:35:11.036724"
"Discrimination - Exception FieldProp - End";"2020-11-05 17:35:13.074781"
"DiscriminationUDMSize - Start";"2020-11-05 17:35:13.076138"
"DiscriminationUDMSize - Start";"2020-11-05 17:35:17.250337"
"Update metrics: start";"2020-11-11 03:05:16.353862"
"Update metrics: end";"2020-11-11 03:05:28.999172"
"Discrimination data - Start";"2020-11-11 03:05:34.843589"
"Discrimination data - LastUpdatedBy";"2020-11-11 03:05:34.849242"
"Discrimination data - Checksum";"2020-11-11 03:05:44.506923"
"Discrimination data - Objects";"2020-11-11 03:05:45.054546"
"Discrimination data - Field props";"2020-11-11 03:06:14.867629"
"Discrimination data - Statistics";"2020-11-11 03:06:17.588111"
"Discrimination data - End";"2020-11-11 03:06:17.702073"
"Discrimination - Start";"2020-11-11 03:06:42.42613"
"Discrimination - End";"2020-11-11 03:09:27.666956"
"DiscriminationEnd - Start";"2020-11-11 03:09:27.668043"
"DiscriminationEnd - End";"2020-11-11 03:10:58.652986"
"Discrimination - Exception FieldProp - Start";"2020-11-11 03:10:58.653348"
"Discrimination - Exception FieldProp - FieldType";"2020-11-11 03:10:58.654681"
"Discrimination - Exception FieldProp - End";"2020-11-11 03:11:00.763999"
"DiscriminationUDMSize - Start";"2020-11-11 03:11:00.765395"
"DiscriminationUDMSize - Start";"2020-11-11 03:11:01.504153"
"Update metrics: start";"2020-12-24 14:50:52.87858"
"Update metrics: end";"2020-12-24 14:51:06.514191"
"Discrimination data - Start";"2020-12-24 14:51:24.077378"
"Discrimination data - LastUpdatedBy";"2020-12-24 14:51:24.085855"
"Discrimination data - Checksum";"2020-12-24 14:51:34.75534"
"Discrimination data - Objects";"2020-12-24 14:51:35.352585"
"Discrimination data - Field props";"2020-12-24 14:52:06.654034"
"Discrimination data - Statistics";"2020-12-24 14:52:09.928199"
"Discrimination data - End";"2020-12-24 14:52:10.101786"
"Discrimination - Start";"2020-12-24 14:52:33.884876"
"Discrimination - End";"2020-12-24 17:09:31.944765"
"DiscriminationEnd - Start";"2020-12-24 17:09:31.945981"
"DiscriminationEnd - End";"2020-12-24 17:10:50.469172"
"Discrimination - Exception FieldProp - Start";"2020-12-24 17:10:50.469489"
"Discrimination - Exception FieldProp - FieldType";"2020-12-24 17:10:50.470524"
"Discrimination - Exception FieldProp - End";"2020-12-24 17:10:52.605078"
"DiscriminationUDMSize - Start";"2020-12-24 17:10:52.606377"
"DiscriminationUDMSize - Start";"2020-12-24 17:10:57.74854"
"Update metrics: start";"2021-05-21 16:24:18.42461"
"Update metrics: end";"2021-05-21 16:24:30.647573"
"Discrimination data - Start";"2021-05-21 16:24:55.930921"
"Discrimination data - LastUpdatedBy";"2021-05-21 16:24:55.937734"
"Discrimination data - Checksum";"2021-05-21 16:25:05.71796"
"Discrimination data - Objects";"2021-05-21 16:25:06.468176"
"Discrimination data - Field props";"2021-05-21 16:25:43.638059"
"Discrimination data - Statistics";"2021-05-21 16:25:46.576742"
"Discrimination data - End";"2021-05-21 16:25:46.687714"
"Discrimination - Start";"2021-05-21 16:26:10.983931"
"Discrimination - End";"2021-05-21 18:48:25.548799"
"DiscriminationEnd - Start";"2021-05-21 18:48:25.550149"
"DiscriminationEnd - End";"2021-05-21 18:49:42.341158"
"Discrimination - Exception FieldProp - Start";"2021-05-21 18:49:42.341471"
"Discrimination - Exception FieldProp - FieldType";"2021-05-21 18:49:42.341906"
"Discrimination - Exception FieldProp - End";"2021-05-21 18:49:44.585762"
"DiscriminationUDMSize - Start";"2021-05-21 18:49:44.587286"
"DiscriminationUDMSize - Start";"2021-05-21 18:49:48.79374"
"Update metrics: start";"2021-12-18 02:25:57.766294"
"Update metrics: end";"2021-12-18 02:26:12.262336"
"Discrimination data - Start";"2021-12-18 02:26:28.926164"
"Discrimination data - Error: project or vanilla not found";"2021-12-18 02:26:28.930144"
"Update metrics: start";"2021-12-29 11:45:24.416706"
"Update metrics: end";"2021-12-29 11:45:38.626935"
"Discrimination data - Start";"2021-12-29 11:45:55.265963"
"Discrimination data - Error: project or vanilla not found";"2021-12-29 11:45:55.269039"
"Update metrics: start";"2022-01-08 13:46:08.756459"
"Update metrics: end";"2022-01-08 13:46:18.870056"
"Discrimination data - Start";"2022-01-08 13:46:40.78421"
"Discrimination data - Error: project or vanilla not found";"2022-01-08 13:46:40.787298"

Query result interpretation

The query returns the description of the discrimination step and the log time

Notes/comments

Related Pages