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:
1 2 3 4 5 6 7 |
SELECT dbo.v_Package.PackageID AS Package, dbo.v_Package.Manufacturer, dbo.v_Package.Name, dbo.v_Package.Version, dbo.v_Program.ProgramName, dbo.v_Program.CommandLine, dbo.v_Program.Comment, dbo.v_Program.Description, dbo.v_Program.ProgramFlags FROM dbo.v_Program INNER JOIN dbo.v_Package ON dbo.v_Program.PackageID = dbo.v_Package.PackageID where (0x00001000 & dbo.v_Program.ProgramFlags)/0x00001000 = 1 order by Manufacturer |
Enabled programs:
1 2 3 4 5 6 7 |
SELECT dbo.v_Package.PackageID AS Package, dbo.v_Package.Manufacturer, dbo.v_Package.Name, dbo.v_Package.Version, dbo.v_Program.ProgramName, dbo.v_Program.CommandLine, dbo.v_Program.Comment, dbo.v_Program.Description, dbo.v_Program.ProgramFlags FROM dbo.v_Program INNER JOIN dbo.v_Package ON dbo.v_Program.PackageID = dbo.v_Package.PackageID where (0x00001000 & dbo.v_Program.ProgramFlags)/0x00001000 != 1 order by Manufacturer |
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.