HP Neoview Release 2.4 Software - Manual (Page 66)

Retrieve Statistics for Completed Queries
This query lists information for the ten most recent queries that terminated normally. You could
enhance this query to filter for time ranges, user IDs, or other attributes.
The list following the query shows values that might be returned in a single record.
select [first 10] *
from NEO.HP_METRICS.ODBC_QUERY_STATS_V2
where STATEMENT_STATE = ’COMPLETE’
ORDER BY QUERY_START_DATETIME DESC
FOR READ UNCOMMITTED ACCESS;
Value Field
\NEO0102 “SEGMENT_NAME”
2 "SEGMENT_ID"
1 "NODE_ID"
653 "PIN"
148 "START_PRIORITY"
\NEO0102.$Z2YK “PROCESS_NAME”
"MXID01001000882212041585284557791000000000509SUPER.SERVICES00" "SESSION_ID"
"511 " "USER_ID"
“ROLE.DBA” “USER_NAME”
"ORDCLOVISRBTS-P2" "CLIENT_ID"
"ODBC Test (ANSI) " "APPLICATION_ID"
"neo0102_clo" "DATASOURCE"
"MXID01001000882212041585284557791000000000509SUPER.SERVICSE00_118
_SQL_CUR_26680060 "QUERY_ID"
"SQL_CUR_26680060 " "STATEMENT_ID"
"SQL_SELECT-NON_UNIQUE" "STATEMENT_TYPE"
"COMPLETE " "STATEMENT_STATE"
"N" "QUERY_TEXT_IS_MULTIROW"
“” "ERROR_CODE"
0 "SEQUENCE_NUM"
2007-05-23 22:30:05.867082 "QUERY_START_DATETIME"
2007-05-23 "QUERY_START_DATE"
22:30:05 "QUERY_START_TIME"
2007-05-24 05:30:05.867610 "QUERY_START_DATETIME_UTC"
2007-05-24 "QUERY_START_DATE_UTC"
05:30:05 "QUERY_START_TIME_UTC"
2007-05-23 22:30:05.867647 "QUERY_END_DATETIME"
2007-05-23 "QUERY_END_DATE"
22:30:05 "QUERY_END_TIME"
2007-05-24 05:30:05.867610 "QUERY_END_DATETIME_UTC"
66 Examples and Guidelines for Creating Repository Queries