SCCM report all applications with dependency programs
Posted by Eswar Koneti on July 11th, 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
March 14th, 2013 at 5:38 PM
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
March 17th, 2013 at 10:57 PM
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.