I am working as an SCCM Admin and using SCCM 2002 for my client. We are upgrading windows from 1709 to 1909. For that we are using 2 Task sequence - one for pre-cache and other for upgrade. There are 2 separate collections on which the TS are deployed. One TS on one collection, the other TS on the other collection. Now, I have a query which gives the deployment status (success, failure, in progress) using the deployment ID. But almost every other day the assets are changed in the collection (query based collection linked to an AD group - Assets are changed in the AD group and they update in the SCCM collection). However, the deployment status does not show it for the updated Assets, it shows for 50-58 assets. The client is after me to come up with a query which can run collection wise (using collection ID as there is only one deployment on that collection) and not deployment wise (which gives results of older assets in the collection as well). How can I fix this? A little urgency here. I am and will use the query to subscribe it to run on a daily basis.