Link to home
Start Free TrialLog in
Avatar of rmessing171
rmessing171Flag for United States of America

asked on

SCCM 2007 - Query IsApproved

I have created the SCCM 2007 Report below to show clients that have the Approved Status of NULL, however it is not working.  If the IsApproved = 1, it will display the NetBIOS Names.  If IsApproved = NULL or 2 or 3, none of the IsApproved statuses of NULL will appear.  Any thoughts of how I can make this work?


SELECT     TOP (100) PERCENT dbo.v_R_System.Netbios_Name0 AS [Computer Name], dbo.v_CM_RES_COLL_SMS00001.IsApproved
FROM         dbo.v_R_System INNER JOIN
                      dbo.v_CM_RES_COLL_SMS00001 ON dbo.v_CM_RES_COLL_SMS00001.ResourceID = dbo.v_R_System.ResourceID
WHERE     (dbo.v_CM_RES_COLL_SMS00001.IsApproved = NULL)
ORDER BY [Computer Name]
ASKER CERTIFIED SOLUTION
Avatar of merowinger
merowinger
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rmessing171

ASKER

Thank you!  This worked like a charm!