meta data for this page
  •  

Különbségek

A kiválasztott változat és az aktuális verzió közötti különbségek a következők.

Összehasonlító nézet linkje

Előző változat mindkét oldalonElőző változat
Következő változat		Előző változat
shell:riportok:napi_riport [2024/05/29 15:50] – adminshell:riportok:napi_riport [2025/05/12 14:56] (aktuális) – admin
Sor 72: Sor 72:
 SQL_QUERY_SESS_V5="SELECT SESSION_ID, CLIENT_NAME, substr(char(start_time),1,19) AS START_TIME,substr(char(days(current_timestamp) - days(start_time)),1,2) AS \"(D)\" ,substr(char((current_timestamp - start_time)hours),1,2) AS \"(HH)\", substr(char((current_timestamp - start_time)minutes),1,2) AS \"(MM)\", STATE,WAIT_SECONDS, cast(float(bytes_sent) /1024/1024 AS DEC(12,2)) AS \"Sent MB\", cast(float(bytes_received) /1024/1024 AS DEC(10,2)) AS \"Rec. MB\" FROM sessions WHERE SESSION_TYPE='Node' and int((current_timestamp - start_time)hours)>$OLD_SESSION_ALERT" # AND (BYTES_RECEIVED>1024*1024 OR BYTES_SENT>1024*1024)" SQL_QUERY_SESS_V5="SELECT SESSION_ID, CLIENT_NAME, substr(char(start_time),1,19) AS START_TIME,substr(char(days(current_timestamp) - days(start_time)),1,2) AS \"(D)\" ,substr(char((current_timestamp - start_time)hours),1,2) AS \"(HH)\", substr(char((current_timestamp - start_time)minutes),1,2) AS \"(MM)\", STATE,WAIT_SECONDS, cast(float(bytes_sent) /1024/1024 AS DEC(12,2)) AS \"Sent MB\", cast(float(bytes_received) /1024/1024 AS DEC(10,2)) AS \"Rec. MB\" FROM sessions WHERE SESSION_TYPE='Node' and int((current_timestamp - start_time)hours)>$OLD_SESSION_ALERT" # AND (BYTES_RECEIVED>1024*1024 OR BYTES_SENT>1024*1024)"
 SQL_Q_FAILED_EVENTS="select substr(node_name,1,17) as \"NODE NAME\", substr(schedule_name,1,23) as \"SCHEDULE NAME\", cast ( SUBSTR ( CHAR ( actual_start ) , 1 , 19 ) as char ( 19 ) ) AS \"ACTUAL START\", substr((completed-scheduled_start)minutes || ' min',1,7) as \"RUNTIME\" , case when result=0 then ' 0-Succesfull' when result=4 then ' 4-Skipped Files' when result=8 then ' 8-Warnings' when result=12 then '12-Errors' else cast(result as char(7)) end as \"RESULT\" from events where (current_timestamp - 24 hours)<scheduled_start and status='Failed' order by node_name" SQL_Q_FAILED_EVENTS="select substr(node_name,1,17) as \"NODE NAME\", substr(schedule_name,1,23) as \"SCHEDULE NAME\", cast ( SUBSTR ( CHAR ( actual_start ) , 1 , 19 ) as char ( 19 ) ) AS \"ACTUAL START\", substr((completed-scheduled_start)minutes || ' min',1,7) as \"RUNTIME\" , case when result=0 then ' 0-Succesfull' when result=4 then ' 4-Skipped Files' when result=8 then ' 8-Warnings' when result=12 then '12-Errors' else cast(result as char(7)) end as \"RESULT\" from events where (current_timestamp - 24 hours)<scheduled_start and status='Failed' order by node_name"
-SQL_NDMP_MENTESEK="SELECT substr(substr(message,locate('/',message),locate(', ',message,locate('/',message)+1)-locate('/',message)),1,30) as VirtualFS, substr(first_record_time,1,16) as START_TIME, TRANSLATE('a bc:de:fg', DIGITS(last_record_time - first_record_time), '_______abcdefgh_____',' ') as Backup_time FROM (\ +SQL_NDMP_MENTESEK="SELECT substr(substr(message,locate('/',message),locate(', ',message,locate('/',message)+1)-locate('/',message)),1,30) as VirtualFS, substr(first_record_time,1,16) as START_TIME, TRANSLATE('a bc:de:fg', DIGITS(last_record_time - first_record_time), '_______abcdefgh_____',' ') as Backup_time, substr(comp_message,locate('completion state of ',comp_message)+20,7) as Result FROM (\ 
-    SELECT pf.message, MIN(al.date_time) AS first_record_time, MAX(al.date_time) AS last_record_time FROM actlog al JOIN ( \ +    SELECT pf.message, pc.comp_message, MIN(al.date_time) AS first_record_time, MAX(al.date_time) AS last_record_time FROM actlog al JOIN ( \ 
-    SELECT process, message FROM actlog WHERE (message LIKE '%Full%/%' or message LIKE '%Diff%/%') AND date_time >= CURRENT TIMESTAMP - 24 HOURS) pf ON al.process = pf.process \ +    SELECT process, message FROM actlog WHERE (message LIKE '%Full%/%' or message LIKE '%Diff%/%') AND date_time >= CURRENT TIMESTAMP - 48 HOURS) pf ON al.process = pf.process \ 
-    WHERE al.date_time >= CURRENT TIMESTAMP - 24 HOURS \ + JOIN ( \ 
-    GROUP BY pf.message \+    SELECT process, message as comp_message FROM actlog WHERE (message LIKE '%bytes with a completion state%') AND date_time >= CURRENT TIMESTAMP - 48 HOURS) pc ON al.process = pc.process \ 
 +    WHERE al.date_time >= CURRENT TIMESTAMP - 48 HOURS \ 
 +    GROUP BY pf.message, pc.comp_message \
 ) order by first_record_time" ) order by first_record_time"
 SQL_Q_SCRATCH="select library_name || ': ' ||substr(MEDIATYPE,1,10) as Media_type, count(*) as Scratch from libvolumes where status='Scratch' group by library_name, MEDIATYPE" SQL_Q_SCRATCH="select library_name || ': ' ||substr(MEDIATYPE,1,10) as Media_type, count(*) as Scratch from libvolumes where status='Scratch' group by library_name, MEDIATYPE"
Sor 85: Sor 87:
 SQL_OFFLINE_PATHOK="select count(*) from paths where not online='YES'" SQL_OFFLINE_PATHOK="select count(*) from paths where not online='YES'"
 SQL_OFFLINE_DRIVEOK="select count(*) from drives where not online='YES'" SQL_OFFLINE_DRIVEOK="select count(*) from drives where not online='YES'"
-SQL_TEVES_PRIV_SZALAGOK="SELECT volume_name, library_name FROM libvolumes WHERE status='Private' AND last_use IS NULL AND volume_name NOT IN (SELECT volume_name FROM volumes) and (owner=(select server_name from status) or owner IS NULL)"+SQL_TEVES_PRIV_SZALAGOK="SELECT volume_name, library_name FROM libvolumes WHERE status='Private' AND last_use IS NULL AND volume_name NOT IN (SELECT volume_name FROM volumes) and (owner=(select server_name from status) or owner IS NULL) and volume_name not in (select volume_name from volhistory where type not in ('STGDELETE','STGNEW'))"
 SQL_PROBLEMAS_VOLUMEOK="select count(*) from volumes where (access!='READWRITE' AND access!='OFFSITE')" SQL_PROBLEMAS_VOLUMEOK="select count(*) from volumes where (access!='READWRITE' AND access!='OFFSITE')"
 SQL_DEAD_NODES="select node_name, (days(current_timestamp)-days(lastacc_time)) as \"LAST ACCESS\" from nodes where locked='NO' and (days(current_timestamp)-days(lastacc_time))>$DEAD_NODE_AGE" SQL_DEAD_NODES="select node_name, (days(current_timestamp)-days(lastacc_time)) as \"LAST ACCESS\" from nodes where locked='NO' and (days(current_timestamp)-days(lastacc_time))>$DEAD_NODE_AGE"