Hp Neoview Release 2.5 Software Instrukcja Użytkownika Pobierz pdf (Strona 72)

Example A-9 Summary of all Events

This report summarizes all events for a given time period and returns results grouped by SSID

and event number.

SELECT

COUNT(*) AS CNT,

EVENT_NUMBER AS EVENT_NUMBER,

CASE

WHEN LEFT(SSID,6) = 'TANDEM'

THEN SUBSTRING(SUBSTRING(SSID

FROM

CHAR_LENGTH('TANDEM. '))FOR LOCATE('.' ,SUBSTRING(SSID

FROM

CHAR_LENGTH('TANDEM. ')) )-1)

ELSE SSID

END AS SUB_SYS,

MIN(GENERATED_TIMESTAMP_LCT) AS FIRST_TIME,

MAX(GENERATED_TIMESTAMP_LCT) AS LAST_TIME,

TRIM(SUBSTRING(MAX(TEXT)

FROM

CHAR_LENGTH('00:00 01FEB09 001.01.1000 ')) ) AS EXAMPLE_EVENT_TEXT,

SSID AS SSID

FROM

NEO.HP_METRICS.EVENTS_VW1

WHERE

GENERATED_TIMESTAMP_LCT >= TIMESTAMP '$$__FROM_TIME$$' and

GENERATED_TIMESTAMP_LCT <= TIMESTAMP '$$__TO_TIME$$'

GROUP BY

SSID,

EVENT_NUMBER

ORDER BY

CNT DESC FOR READ UNCOMMITTED ACCESS IN SHARE MODE

;

Sample Query Result

This example shows a report summarizing all events for a given time period and returns results

grouped by SSID and event number.

72 Sample Queries for Event Information

1 2 ... 67 68 69 70 71 72 73 74 75 76 77 ... 141 142

Brak uwag

Hp Neoview Release 2.5 Software Instrukcja Użytkownika Strona 72