I have an AI job that pulls a list of InstanceId values from a remedy form. This list is passed into a Table Input step, to be executed for each row, and used as part of the SQL query. If no results are found, I have an Emptry Stream branch that is taken. How do I get the InstanceId that was used in the Table Input step which found no results? The Empty Stream is, of course empty. I need to know which InstanceId returned no results so I can take the appropriate action.
The top branch processes the found results and pushes data into the CMDB. The bottom branch triggers when an empty stream is detected. This bottom branch needs to log the InstanceId that failed to return data in the Table Input step.