SCCM report all applications with dependency programs
Posted by Eswar Koneti on 11th July 2012
Though it is simple to write query but some times find difficulty to track what applications are using other packages as dependency.
Many Microsoft applications like visual C++ ,.net framework etc are needed by other applications as dependency but how do we know them ?
SCCM database stores the dependency applications as programs as one package may contains many programs and is not good idea to go with package as dependency.
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
Tags: CM07, configuration Manager report dependency applications, dependency apps, report for all applications with dependencies., report for run another program first, sccm report dependent applications list, SQL code
Posted in SCCM 2007, SCCM Reports, SQL Quiries | 2 Comments »