Close Menu
    Facebook X (Twitter) Instagram
    Sunday, July 20
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»SCCM 2007»#SCCM / #Configmgr Report TS Packages not distributed to DP

    #SCCM / #Configmgr Report TS Packages not distributed to DP

    Eswar KonetiBy Eswar KonetiNovember 06, 8:53 am1 Min Read SCCM 2007 3,061 Views
    Share
    Facebook Twitter LinkedIn Reddit

    In previous post,we saw how to get list of referenced task sequence packages used in Task Sequence which are incomplete.

    In this report,we see how to get list of Distribution Points who do not have these referenced packages used in Task Sequence so you know all these sites which do not have package may fail during the OSD Policy check.

    Count  : Distribution Points who do not have these packages used in Task Sequence

    select sitecode,COUNT(distinct packageID) as [Not Distributed] from v_PackageStatusDetailSumm PSD
    where PSD.Targeted='0' and PSd.PackageID in (select ReferencePackageID from v_TaskSequenceReferencesInfo
    where PackageID =@TS1)
    group by psd.SiteCode
    order by psd.sitecode

    what Task Sequence Reference packages missing from Which DP :

    select PSD.PackageID,PSD.Name,psd.SiteCode,PSD.SiteName,PSD.SummaryDate  from v_PackageStatusDetailSumm PSD
    where PSD.Targeted='0' and PSd.PackageID in (select ReferencePackageID from v_TaskSequenceReferencesInfo
    where PackageID =@TS1)
    Group by PSD.PackageID,PSD.Name,psd.SiteCode,PSD.SiteName,PSD.SummaryDate
    order by SiteCode

    Prompt for TS1 :

    select PackageID,Name from v_TaskSequencePackage

    Fix it before you advertise any Task Sequence to Computers .

    CM07 Count of TS packages missing on which Distribution Distribution Point TS packages missing Reference Packages used in Task Sequence report SCCM sccm report SCCM report for Task sequence packages missing on Which DP Task Sequence Task Sequence reference Packages Status Report Troubleshooting tip on SCCM report
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM SQL Report – Compare Installed Apps on TWO Different Computers

    July 13, 10:35 am

    Optimize Your Intune Workflow with a Powerful Browser Extension

    March 22, 10:39 am

    Migrate Microsoft 365 Updates from SCCM/MECM to Intune for Co-Managed Devices

    February 11, 9:50 pm

    Leave a ReplyCancel reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

    © Copyright 2009-2024 Eswar Koneti, All rights reserved.

    Type above and press Enter to search. Press Esc to cancel.