Report for all deployments

Question

I wold like to get a report with all deployments for each device, it's better to get the deployment status too.

Answer 1

Hi, @Algkindom

Thank you for posting in Microsoft Q&A forum.

Here is an example to get all deployed programs and status:

SELECT SYS.Netbios_Name0, ADV.AdvertisementID, ADV.AdvertisementName, 
    COL.Name AS TargetedCollection, CAS.LastStatusMessageIDName 
    FROM v_ClientAdvertisementStatus CAS INNER JOIN v_R_System SYS 
    ON CAS.ResourceID = SYS.ResourceID INNER JOIN v_Advertisement ADV 
    ON CAS.AdvertisementID = ADV.AdvertisementID INNER JOIN 
    v_Collection COL ON ADV.CollectionID = COL.CollectionID 
    ORDER BY SYS.Netbios_Name0, ADV.AdvertisementID

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".