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