Close Menu
    Facebook X (Twitter) Instagram
    Monday, May 19
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»SCCM 2007»SCCM report software Distribution Packages with No Advertisements

    SCCM report software Distribution Packages with No Advertisements

    Eswar KonetiBy Eswar KonetiOctober 10, 8:50 pm1 Min Read SCCM 2007 2,130 Views
    Share
    Facebook Twitter LinkedIn Reddit

    If you are Performing package cleanup,this query might help you to Identify how many packages with no advertisements(standard advertisement and Task Sequence)

    so you know What action to Take next!

    select  v_Package.PackageID, v_Package.Name,v_Package.SourceVersion,v_Package.SourceDate
    from dbo.v_package
    Where
    packageID not in (select PackageID from dbo.v_Advertisement)and
    PackageID not in (SELECT ReferencePackageID FROM v_TaskSequenceReferencesInfo) and
    v_Package.name not like '%osd%' and V_package.PackageType ='0'

    group by v_Package.PackageID, v_Package.Name,v_Package.SourceVersion,v_Package.SourceDate

    order by v_Package.PackageID

    If you want to know other packages like OSD,Driver,Software update packages,you can replace Package type with below Values :

    When 3 Then ‘Driver Package’
    When 4 Then ‘Task Sequence Package’
    When 5 Then ‘software Update Package’
    When 6 Then ‘Device Settings Package’
    When 7 Then ‘Virtual Package’
    When 257 Then ‘Image Package’
    When 258 Then ‘Boot Image Package’
    When 259 Then ‘OS Install Package’

    Package type packages with no Advertisements report sccm report software distribution report software package Type
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    Monitoring Endpoint Security Applications with SCCM ConfigMgr SQL

    October 11, 8:48 pm

    SCCM Right Click Tool Managed workloads of co-managed device

    September 25, 6:08 pm

    SCCM report list collections with no deployments

    December 05, 12:04 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.