Wednesday, September 8, 2010

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.

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home