[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 464
  • Last Modified:

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]
0
rmessing171
Asked:
rmessing171
1 Solution
 
merowingerCommented:
try:


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 is NULL
ORDER BY [Computer Name]
0
 
rmessing171Author Commented:
Thank you!  This worked like a charm!
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Tackle projects and never again get stuck behind a technical roadblock.
Join Now