Central Log View

The log viewer can be configured via its "settings" button. In the corresponding dialog you find a new button "Filter" which allows you to specify the system logs which are streamed into the log viewer.

Every DIM stream which we can see on the log viewer is automatically put into an Oracle table (INTR,ATLAS_PVSSLOG_R,PVSSRED4LOG).

SQL Example:
1) SELECT * FROM ATLAS_DCS_PVSS_LOGS WHERE ROWNUM<10 AND SYSTEM_ID='ATLMDTSCS' ORDER BY ID DESC;

2) SELECT * FROM ATLAS_DCS_PVSS_LOGS WHERE PVSS_TS >= TO_DATE('13.09.2007', 'DD.MM.YYYY') AND SYSTEM_ID='ATLMDTSCS' and body like '%license%' ORDER BY ID DESC;

Data Example:

TS SYSTEM_ID MANAGER_ID USERNAME BODY MSG_COMMENT
13-SEP-07 10.46.45.2827 AM ATLMDTSCS PVSS00dim3.6 (1) n/a Got connection to system 103
13-SEP-07 10.46.45.2816 AM ATLMDTSCS PVSS00data (0) n/a Got connection to system 103
13-SEP-07 10.46.45.2815 AM ATLMDTSCS PVSS00ctrl (2) root Got connection to system 103
13-SEP-07 10.46.45.2814 AM ATLMDTSCS PVSS00ctrl (4) root Got connection to system 103
13-SEP-07 10.46.45.2812 AM ATLMDTSCS PVSS00ctrl (3) root Got connection to system 103
13-SEP-07 10.46.45.2811 AM ATLMDTSCS PVSS00smi (10) n/a Got connection to system 103
13-SEP-07 10.46.45.2810 AM ATLMDTSCS PVSS00ctrl (5) root Got connection to system 103
13-SEP-07 10.46.45.2809 AM ATLMDTSCS PVSS00ctrl (50) root Got connection to system 103
13-SEP-07 10.46.45.2808 AM ATLMDTSCS PVSS00ctrl (1) root Got connection to system 103

Table Structure:

Name Null? Type
ID NOT NULL NUMBER(38)
TS NOT NULL TIMESTAMP(4)
PVSS_TS TIMESTAMP(3)
SYSTEM_ID VARCHAR2(256)
MANAGER_ID VARCHAR2(256)
USERNAME VARCHAR2(256)
PRIORITY NUMBER(1)
ETYPE NUMBER(1)
CODE NUMBER(5)
BODY VARCHAR2(4000)
DP_ID NUMBER(20)
MSG_COMMENT VARCHAR2(4000)

Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r2 - 2007-09-13 - StepanKovar
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    Atlas All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback