SCCM Reports - v_R_System vs v_GS_System

Author
gesmith40
New Member
  • Total Posts : 1
  • Scores: 0
  • Reward points: 0
  • Joined: 2009/07/20 13:10:02
  • Status: offline
2009/07/20 14:42:49 (permalink)
0

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
#1

1 Reply Related Threads

    gjones
    Expert Member
    • Total Posts : 2816
    • Scores: 146
    • Reward points: 247630
    • Joined: 2001/06/05 12:32:00
    • Location: Ottawa, Ontario, Canada
    • Status: offline
    RE: SCCM Reports - v_R_System vs v_GS_System 2009/07/20 14:53:53 (permalink)
    0
    Any PC with data in the v_GS_* views have the ConfigMgr agent installed.

    Any PC with data in the v_R_System view and does NOT have data within v_GS_* views means that device has only be discovered and does NOT have the ConfigMgr client installed.
    #2
    Jump to:
    © 2018 APG vNext Commercial Version 5.5