generate report for the packages not available in Source Distribution point

Question

Hello Team,

We have created a Pull Distribution Point and added source distribution points to the pull distribution point.

Under \Monitoring\Overview\Distribution Status\Distribution Point Configuration, the Status of packages saying that content not available in Source distribution point.

In that case how to generate a report saying the contentsnot available in the source distribution point.

Answer 1

Hi, @Boopathi S

Thank you for posting in Microsoft Q&A forum.

You may use a SQL query to check the status of packages and filters those that have a specific condition,

MessageState = 1 means success

MessageState = 2 means In Progress

MessageState = 4 means Failed

But I'm afraid there isn't a state "not available", remember to replace DPSD.DPName with your pull DP name.

Here is an example to get the package with status failed to distribute.

SELECT distinct DPSD.DPName, DPSD.PackageID, SP.Name, DPSD.MessageState, DPSD.LastStatusTime, DPSD.SiteCode
FROM vSMS_DPStatusDetails DPSD
JOIN SMSPackages_All SP ON DPSD.PackageID = SP.PkgID
WHERE DPSD.DPName = 'FQDN of PullDP' and DPSD.MessageState = 4

---

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".