Find all the SMS Packages with disabled programs

SELECT
*
FROM
dbo.v_Program p
Where
(0x00001000 & p.ProgramFlags)/0x00001000 = 1

Description:

The Above simple query will get you the list of all packages which have a disabled program in SMS Admin Console.