SCCM Reports - v_R_System vs v_GS_System
I am new to SCCM and have some basic questions I am hoping someone can help with. I am trying to create a report to show a basic list of all computers in system. However, I have done a couple of queries and get different results with each. Doing a basic query using v_R_System, I get a list of systems as I would expect. However, when I do another query and join v_GS_OperatingSystem using ResourceID, I get another list that is about 1800 units less than the basic list. I am showing query below for review. Looks like I have about 1800 machines that do not have a last boot time listed. Does anyone have any suggestions as to how to get a reliable/believable list of machines (short of a physical inventory!)?
Also - can someone explain for is basic difference between the v_R_System and v_GS_System views? I know one shows "discovered" devices while other is list from Configuration manager. Just trying to understand which to use to create reports from. Thank you...
SELECT DISTINCT
v_R_System.Name0 AS [Computer Name], v_R_System.Resource_Domain_OR_Workgr0 AS Domain, v_R_System.User_Name0 AS UserID,
v_R_System.Operating_System_Name_and0 AS [Operating System], v_GS_OPERATING_SYSTEM.LastBootUpTime0 AS [Last BootUp Time]
FROM v_R_System INNER JOIN
v_GS_OPERATING_SYSTEM ON v_R_System.ResourceID = v_GS_OPERATING_SYSTEM.ResourceID
ORDER BY v_R_System.Resource_Domain_OR_Workgr0,
v_R_System.Name0