During a maintenance procedure, we are checking for a certain "state" (say, a file exists). If that state is true, I want to get the x most recent procedures to make a determination of how that state was achieved.

Playing with Database Views, it only seems to return a single procedure, and not even the most recent one.

Is there a way to use the GetVariable statement to retrieve a list of recent procedures from SQL View Data, or is there maybe a better way to accomplish this?

Thanks in advance,
Matt