I'm needing to write a query to identify current 'Bad' Values and the last time they were 'Good'.
Identifying the 'Bad' Values is working nicley but I have not been able to find a way to find the last 'Good' Value.
Here is the query for the current Bad values.
select tag as Tag,
DIGSTRING(status) As Status,
time as Curr_Time_Stamp
where tag in (
select tag from pipoint..classic
where tag LIKE ''%BADTAGS%'')
and DIGSTRING(status) = ''Bad''
order by time
Any suggestions on how to find the last good value?
Thanks in advance for any suggestions!