Sql query for gathering application and deployment information from SCCM/MECM

Sometimes you need a list of application available within System center. here is a script to gather that information



1/9/20241 min read

I am doing an application rationalization while in the process of merging two SCCM/MECM instances into one. This requires that I know what applications are packaged and deployed to either side, as well as, some additional useful information.

In the script below I am gathering All the applications that are currently deployed within my organization. You'll notice I commented out some of the lines of the script. This information will be split to go to different groups within my organization and some will just want application names whilst others may need to know the install/uninstall commands, and so on.