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:

Table Structure: