Solved

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

Posted on 2013-12-17
1
264 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

Why do Marketing keep bothering you?

Is your marketing department constantly asking for new email signature updates? Are they requesting a different design for every department? Do they need yet another banner added? Don’t let it get you down! There is an easy way to manage all of these requests...

Join & Write a Comment

To effectively work with Diskpart on a Server Core, it is necessary to write some small batch script's, because you can't execute diskpart in a remote powershell session. To get startet, place the Diskpart batch script's into a share on your loca…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

762 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now