I am looking for a query to list all the active packages within SCCM. I believe there are a few 'stuck' packages within a few DP's which need to be removed manually. has anyone done this and if so what is the 'cleanest' way of removing the package(s) from certain DPs. Also if I have remove some of the existing Software updates deployment packages, how can I go about removing them without causing any adverse effects on the client machines which have received them / in the process of receiving them?

I'm not really sure what you mean by "stuck" packages. But if you are looking for a sql query to tell you which packageids are NOT currently in use by an Advertisement... use v_advertisementinfo select * from v_package p where p.packageid not in (select packageid from v_AdvertisementInfo) Just keep in mind that will also tell you packageids from OSD packages, and Software Update Packages, and TaskIDs in Task Sequences; so just keep that in mind. As for your 2nd question about software Updates; you may have to take that in multiple stages: Remove the patch from the DM; wait; remove the patch from the package.Standardize. Simplify. Automate.

I'm not really sure what you mean by "stuck" packages. But if you are looking for a sql query to tell you which packageids are NOT currently in use by an Advertisement... use v_advertisementinfo select * from v_package p where p.packageid not in (select packageid from v_AdvertisementInfo) Just keep in mind that will also tell you packageids from OSD packages, and Software Update Packages, and TaskIDs in Task Sequences; so just keep that in mind. As for your 2nd question about software Updates; you may have to take that in multiple stages: Remove the patch from the DM; wait; remove the patch from the package.Standardize. Simplify. Automate.

Thank you for your response Sherry. I am in the process of trying this out.