SCCM 2007 - Query IsApproved
Posted on 2013-12-16
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]