select "BACKUPFAILURES"."OWNER" as "Owner",
"BACKUPFAILURES"."SERVERNAME" as "Servername",
"BACKUPFAILURES"."NAME" as "Databasename",
"BACKUPFAILURES"."DBID" as "Database ID",
"BACKUPFAILURES"."LETZTES_INC0" as "Last INC0",
"BACKUPFAILURES"."INC0DAYS" as "Days INC0",
"BACKUPFAILURES"."LETZTES_ARCH" as "Last Arch",
"BACKUPFAILURES"."ARCHDAYS" as "Days Arch",
"BACKUPFAILURES"."AELTESTES_BACKUP" as "Oldest Backup",
"BACKUPFAILURES"."OLDDAYS" as "Days Backup"
from "BACKUPFAILURES" "BACKUPFAILURES"
where
(
instr(upper("OWNER"),upper(nvl(:P1_REPORT_SEARCH,"OWNER"))) > 0 or
instr(upper("SERVERNAME"),upper(nvl(:P1_REPORT_SEARCH,"SERVERNAME"))) > 0 or
instr(upper("NAME"),upper(nvl(:P1_REPORT_SEARCH,"NAME"))) > 0 or
instr(upper("DBID"),upper(nvl(:P1_REPORT_SEARCH,"DBID"))) > 0 or
instr(upper("LETZTES_INC0"),upper(nvl(:P1_REPORT_SEARCH,"LETZTES_INC0"))) > 0 or
instr(upper("INC0DAYS"),upper(nvl(:P1_REPORT_SEARCH,"INC0DAYS"))) > 0 or
instr(upper("LETZTES_ARCH"),upper(nvl(:P1_REPORT_SEARCH,"LETZTES_ARCH"))) > 0 or
instr(upper("ARCHDAYS"),upper(nvl(:P1_REPORT_SEARCH,"ARCHDAYS"))) > 0 or
instr(upper("AELTESTES_BACKUP"),upper(nvl(:P1_REPORT_SEARCH,"AELTESTES_BACKUP"))) > 0 or
instr(upper("OLDDAYS"),upper(nvl(:P1_REPORT_SEARCH,"OLDDAYS"))) > 0
)
and
(
ARCHDAYS>=1
or
OLDDAYS>=35
or
INC0DAYS>=8
)



1 mal bearbeitet. Zuletzt am .