SCCM Unused Packages

Find Unused Packages in SCCM DECLARE @ObjectTypes TABLE (ObjectType INT PRIMARY KEY, TypeDescription VARCHAR(46)); INSERT INTO @ObjectTypes (ObjectType,TypeDescription) VALUES(2,'Package'); INSERT INTO @ObjectTypes (ObjectType,TypeDescription) VALUES(3,'Advertisement'); INSERT INTO @ObjectTypes (ObjectType,TypeDescription) VALUES(7,'Query'); INSERT INTO @ObjectTypes (ObjectType,TypeDescription) VALUES(8,'Report'); INSERT INTO @ObjectTypes (ObjectType,TypeDescription) VALUES(9,'MeteredProductRule'); INSERT INTO @ObjectTypes (ObjectType,TypeDescription) VALUES(11,'ConfigurationItem'); INSERT INTO @ObjectTypes (ObjectType,TypeDescription) VALUES(14,'OperatingSystemInstallPackage'); INSERT INTO @ObjectTypes (ObjectType,TypeDescription) VALUES(17,'StateMigration'); INSERT... Continue Reading →


Report to list Boundary Group with Site System Details

select sys1.Name, sys1.DefaultSiteCode, (select SUBSTRING(sys2.ServerNALPath, CHARINDEX('\\', sys2.ServerNALPath) + 2, CHARINDEX('"]', sys2.ServerNALPath) - CHARINDEX('\\', sys2.ServerNALPath) - 3 ) + CASE sys2.Flags WHEN '1' Then ' (Slow)' WHEN '0' THEN '' END + '; ' as 'data()' from vSMS_BoundaryGroupSiteSystems as sys2 where sys1.GroupID=sys2.GroupID for XML path('')) as 'Site System', (select sys4.Value + '; ' as 'data()' from... Continue Reading →

Create a free website or blog at

Up ↑