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
shell:riportok:napi_riport [2024/06/14 15:57] – adminshell:riportok:napi_riport [2025/05/12 14:56] (aktuális) – admin
Sor 87: 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"