Hi to all
It’s a new feature in O.C call node at risk with three values:
· Default Interval
· Bypass
· Custom
I created script to isolate nodes for bypass and custom value but no success
for Default interval.
The option parameter is ATRISK_TYPE for them are on a select command as:
· Default internal no value (blank)
· Bypass 0
· Custom 1
I tried all the possible combination I know but impossible to get the nodes
with Default Interval.
Script for bypass as: select node_name as "Bypass Nodes at Risk" from
nodes where ATRISK_TYPE=0 order by 1
Script for custom as: select node_name as "Custom Nodes at Risk",
ATRISK_INTERVAL as "Interval Risk in Hours" from nodes where ATRISK_TYPE=1
Tried for default but wrong output: select node_name as "Default Nodes at
Risk" , ATRISK_INTERVAL as "Interval Risk" , ATRISK_TYPE from nodes where
ATRISK_TYPE <> '0' or ATRISK_TYPE <> '1'
select node_name as "Default Nodes at Risk" , ATRISK_INTERVAL as "Interval Risk
i" , ATRISK_TYPE from nodes where ATRISK_TYPE not like ('%%0%%') or
ATRISK_TYPE not like ('%%1%%')
Best Regards
Robert
