Depended Package

by Garth 26. January 2012 01:32

Use this query to get the package name for any depended program.

See the TechNet forum post for full details.

SELECT     
  Pkg.Name AS 'Package Name', 
  ADV.ProgramName AS 'Program Name',
  ADV.AdvertisementName AS 'Advertisement Name', 
  Col.Name AS 'Collection Name', 
  CRQ.RuleName AS 'Security Group Name',
  Pgm.PackageID, 
  Pgm.ProgramName, 
  Pgm.DependentProgram,
  pkgsub.Name
  
FROM
  dbo.v_Advertisement Adv
  INNER JOIN dbo.v_Collection Col ON ADV.CollectionID = Col.CollectionID 
  INNER JOIN dbo.v_Package Pkg ON ADV.PackageID = Pkg.PackageID 
  INNER JOIN dbo.v_CollectionRuleQuery CRQ ON Col.CollectionID = CRQ.CollectionID 
  INNER JOIN dbo.v_Program Pgm ON Pkg.PackageID = Pgm.PackageID
  left outer Join (select substring(Pgm.DependentProgram,0,9) as Subpac, PackageID from dbo.v_Program  Pgm where Pgm.DependentProgram != '') sub ON sub.PackageID = Pkg.PackageID 
  left outer JOIN dbo.v_Package Pkgsub ON sub.Subpac = Pkgsub.PackageID 
--where 
--  ADV.AdvertisementName like 'Z7_%' 
ORDER BY 
  ADV.AdvertisementName

Tags: ,

System Management Server | System Center Configuration Manager | SCCM | SMS

Comments are closed

Powered by BlogEngine.NET 1.6.0.0


Enhansoft is an information technology company specializing in Windows Management development, implementation and customization for:

  • System Center Configuration Manager v.Next
  • System Center Configuration Manager (ConfigMgr / SCCM)
  • System Management Server (SMS)
  • Virtual environments (Hyper-v / Virtual Server)

We focus on helping you manage your technology needs through our portfolio of world-class products and services.

Tag cloud