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]