SCCM report all applications with dependency programs

 

I had requirement to check for some specific packages if their programs are used in any other packages or not . Take an example that ,Microsoft visual C++ is prereq for multiple applications and to know what packages used this specific VC++ ,it will be hard to find all parent packages using VC++ as dependency program.

How do we get list of all packages that are using specific application as dependency ? in this case it is VC++.

In SCCM ,depedent programs are stored in view called 'v_Program' with column name 'DependentProgram' .So we can use this view to retrive the information for VC++.

Here is simple report that provides all packages which are used by dependent ones.

Manual method report:

select ProgramName, PackageID,ProgramName from v_Program
where DependentProgram like
'%MicrosoftVisualC++Redistributable_2008%'

Prompting report :

select ProgramName, PackageID,ProgramName from v_Program
where DependentProgram =@dependencypgm

Prompt for dependencypgm: Select DependentProgram from v_Program

Note: SCCM stores dependent program as packageID;programname where  packageID is main application where dependency used and program is run another program first.
also refer blog post by Garth http://support.enhansoft.com/Blogs/post/Depended-Package.aspx

2 Responses to "SCCM report all applications with dependency programs"

  1. Hi Eswar,

    select ProgramName, PackageID,ProgramName from v_Program
    where DependentProgram like
    ‘%MicrosoftVisualC++Redistributable_2008%’

    I hope the query provided will fetch the packages that use Visual C++ as dependency. If it is so,
    is there any possiblity to get the status of the packages that are used as dependency for other main application?

    Thanks in advance!

    Regards
    Sridhar

    Reply
    1. I don't think so because the dependency program will not have any advertisements just installation program which will be triggered by its parent adv.
      if you need the status of the dep program,you can create report based on its status messages.never tried it before.

      Reply

Leave a Reply