Table 28. Usage Tracking Data
Column
|
Description
|
UserName
|
The name of the user who submitted the query.
|
RepositoryName
|
The name of the repository the query accesses.
|
BusinessModelName
|
The name of the business model being accessed.
|
NodeID
|
(Reserved for future use.)
|
Start timestamp
|
The date and time the logical query was submitted.
|
Start date
|
The date the logical query was submitted.
|
Start hourMin
|
The hour and minute the logical query was submitted.
|
End timestamp
|
The date and time the logical query finished. The start and end timestamps also reflect any time the query spent waiting for resources to become available.
|
End date
|
The date the logical query was completed.
|
End hourMin
|
The hour and minute the logical query was completed.
|
QueryText
|
The SQL submitted for the query.
|
SuccessFlag
|
The completion status of the query:
0 - The query completed successfully with no errors.
1 - The query timed out.
2 - The query failed because row limits were exceeded.
3 - The query failed due to some other reason.
|
RowCnt
|
The number of rows returned to the query client.
|
TotalTimeInSecs
|
The time in seconds required to compile and execute the query. This reflects only the time spent actually processing the query.
|
CompileTimeInSeconds
|
The time in seconds required to compile the query.
|
NumDBQueries
|
The number of queries submitted to back-end databases in order to satisfy the logical query request. For successful queries (SuccessFlag = 0) this number will be 1 or greater.
|
CumDBTimeInSecs
|
The total time in seconds spent computing back-end database queries.
TotalTimeInSecs minus CumDBTimeInSecs equals the time spent within the Siebel Analytics Server.
|
CumDBRows
|
The total number of rows returned by the back-end databases.
|