Eswar Koneti's Blog

All about Configmgr and its connected objects…….

  • About Author
       View eswar koneti's LinkedIn profile

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 99 other subscribers

  • Awards


  • FaceBook Updates

  • Catagories

  • Meta

  • Copyright!

    All the blog posts in this website are owned by Eswar Koneti and may not be reused in any mode without prior approval of Eswar Koneti. You may quote one paragraph from the blog posts if you link to the original blog post.
    Happy Reading!

«
»

SCCM Report Packages with no distribution Points Added

Posted by Eswar Koneti on October 3rd, 2012

Today I was looking at Packages to see how many packages are created without any distribution Points added. This might help you in identifying whether these packages are really needed to be in SCCM or

archive them. This below report will help you in achieving this.

select PackageID,Name,Version,SourceDate from v_Package where PackageID not in (select packageid from v_PackageStatusDistPointsSumm)

Note : Some packages might use just command line (script based) and they do not have any distribution Points . Double Verify them before you take any action)

Tags: , , , , , , , , ,
This entry was posted on Wednesday, October 3rd, 2012 at 11:12 AM and is filed under SCCM, SCCM 2007, SCCM Reports, SQL Quiries, WQL Quiries. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

«
»