Solved

SCCM 2007 - Query IsApproved

Posted on 2013-12-16
2
437 Views
Last Modified: 2013-12-18
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
Comment
Question by:rmessing171
2 Comments
 
LVL 31

Accepted Solution

by:
merowinger earned 500 total points
ID: 39725926
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
 

Author Comment

by:rmessing171
ID: 39727023
Thank you!  This worked like a charm!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Robocopy all drives in windows 2 39
Trust relationship when doing server upgrades 3 43
Reverse DND setup 6 38
Migrating Roaming Profiles to new server 5 24
Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
Redirected folders in a windows domain can be quite useful for a number of reasons, one of them being that with redirected application data, you can give users more seamless experience when logging into different workstations.  For example, if a use…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question