SQL query for all ConfigMgr disabled and enabled programs

A question popped up on the MyITForum mssms emailing list this week about a SQL query to get all enabled programs in ConfigMgr. This can be a bit tricky if you have never played with the programflags and their conversions to get this data.

Garth Jones had the basis for the conversion and I just added a few more columns and a join to get the Package information as well.

http://smsug.ca/blogs/garth_jones/archive/2010/06/23/list-of-disabled-programs.aspx

Disabled programs:

Enabled programs:

2 thoughts on “SQL query for all ConfigMgr disabled and enabled programs

  1. Fiona

    Hi Id like to test the above query, can i use it in a reportto display a list of disbled programs?

    • Yes, you should be able to put either query into a asp report in ConfigMgr 2007 or a SSRS report in ConfigMgr 2012.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">