SQL Query to check the OSD Status

Question

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'

Answer 1

Hi,

Thank you for coming Microsoft MECM Q&A forum.

Here are some articles for your reference, hope they can do some help:
SQL Query to track OSD
Monitor OSD with Status Message Queries in ConfigMgr 2012

Thanks for your time.

Best regards,
Simon

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

You can use the following report to get detailed deployment status