Objective is to create a SCCM report which can help the Monitoring team understand which machine have been built successfully via SCCM OSD. We have not removed Continue on error from some steps because even though they install successfully, they show as fail in the logs.
Hence, we are trying to create this report with few conditions e.g. Action1-4 are successful and 11143 is found then the Build is successful. Following is my Work in progress query but it is returning 400000+ lines which are not even relevant. Please suggest.
Select ResourceID,LastStatusMessageIDName,LaststatusMessageID,
case
when ActionName = 'Action1' and LastStatusMessageIDName = 'The task sequence execution engine successfully completed an action' then 'Success'
when ActionName = 'Action2' and LastStatusMessageIDName = 'The task sequence execution engine successfully completed an action' then 'Success'
when ActionName = 'Action3' and LastStatusMessageIDName = 'The task sequence execution engine successfully completed an action' then 'Success'
when ActionName = 'Action4' and LastStatusMessageIDName = 'The task sequence execution engine successfully completed an action' then 'Success'
when LastStatusMessageID = '11143' then 'Success'
END AS Status
from v_TaskExecutionStatus where AdvertisementID = 'PS132862'