rmessing171
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_Nam e0 AS [Computer Name], dbo.v_CM_RES_COLL_SMS00001 .IsApprove d
FROM dbo.v_R_System INNER JOIN
dbo.v_CM_RES_COLL_SMS00001 ON dbo.v_CM_RES_COLL_SMS00001 .ResourceI D = dbo.v_R_System.ResourceID
WHERE (dbo.v_CM_RES_COLL_SMS0000 1.IsApprov ed = NULL)
ORDER BY [Computer Name]
SELECT TOP (100) PERCENT dbo.v_R_System.Netbios_Nam
FROM dbo.v_R_System INNER JOIN
dbo.v_CM_RES_COLL_SMS00001
WHERE (dbo.v_CM_RES_COLL_SMS0000
ORDER BY [Computer Name]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER