Solved

SCCM Reporting - Runing Report Against All Systems Collection - Not Appearing

Posted on 2013-12-17
1
266 Views
Last Modified: 2014-03-04
I am running the following SCCM Report query against the All Systems Collection, however clients that have the Approval = N/A or Not Approved are not being reported.

Any ideas on how I can get the Approval = N/A and Not Approved resources to appear in my report?

SELECT     TOP (100) PERCENT B.Netbios_Name0 AS [Computer Name], A.Model0, B.Client0
FROM         dbo.v_GS_COMPUTER_SYSTEM AS A INNER JOIN
                      dbo.v_R_System AS B ON A.ResourceID = B.ResourceID INNER JOIN
                      dbo.v_FullCollectionMembership AS C ON A.ResourceID = C.ResourceID
WHERE     (C.CollectionID = @CollectionID)
ORDER BY [Computer Name]
0
Comment
Question by:rmessing171
1 Comment
 
LVL 31

Accepted Solution

by:
merowinger earned 500 total points
ID: 39850450
Try the following:
SELECT  DISTINCT  SYS.Netbios_Name0 AS [Computer Name], PC.Model0, SYS.Client0
FROM         dbo.v_R_System AS SYS
LEFT OUTER JOIN dbo.v_GS_COMPUTER_SYSTEM AS PC ON PC.ResourceID = SYS.ResourceID 
LEFT OUTER JOIN dbo.v_FullCollectionMembership AS COLL ON PC.ResourceID = COLL.ResourceID 
ORDER BY [Computer Name] 

Open in new window

0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

I was asked if I could set up a fax machine so that incoming faxes were delivered to people's Exchange inboxes and so that they could send faxes from their desktops without needing to print the document first.  I knew it was possible but I had no id…
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 locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

776 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