Requery if value is NULL

Question

Hello I'm new to scripting and I'm trying to get the latest IP SLA statistics of a pair of devices. I'm able to get them without an issue however there are times that I'm getting NULL values as result which messes up my script. I need to get  non-Null values for both Device1 and Device2 so I can compare them and make a decision based of their results.

If I add a WHERE <column> IS NOT NULL, I could get only 1 result or non at all if there's a NULL value at the time of query which is the problem, i need to get result for both device1 and device2. Is there a way to re-run my queries until the value is not NULL or optimize my queries so that I could get the last non-NULL value inserted of the table?  I'm hoping this can be done on the SWQL queries before I pass the result to my script.

Thanks in advanced.

Here's my sample script:

SELECT OperationInstanceID, RoundTripTime, Latency, Jitter, PacketLoss

FROM Orion.IpSla.OperationCurrentStats

WHERE RecordTime >= ADDDATE('SECOND', -30, GETDATE()) AND OperationInstanceID = '1' OR OperationInstanceID = '2'

OperationInstanceIDRoundTripTimeLatencyJitterPacketLoss188.100000381469731022NULLNULLNULL

thwackeroo · Answer

Thanks for the feedback, yeah was hoping to fix the null value on the DB query prior to passing it on my script vs to catching it on the script then sending another query back to DB.

Jfrazier · Answer

The NULL indicates a value was not retrieved for that device/port/interface.  This could be for whatever reason.

Now, was it dropped because system resources were low or were there other reasons. Unknown but your script needs to be able to handle the NULL data as part of its input.  One of the joys of scripting is you have to account for all the possible values or lack of values in your input data....programming101.