Can anyone please help me built an efficient query that search:
from DiscoveredCommandResult table
where previous result is not the current result,
and where the current command and the previous command are the same,
and will show me the following collomns: command, result, failure, IP.
The current result/command doesn't need to be the latest one.
Thank you in advance,