myITforum and Windows IT Pro Forums

 SCCM Reports - v_R_System vs v_GS_System

Author Message
gesmith40

  • Total Posts : 1
  • Scores: 0
  • Reward points : 0
  • Joined: 7/20/2009
  • Status: offline
SCCM Reports - v_R_System vs v_GS_System Monday, July 20, 2009 2:42 PM (permalink)
0
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
    gjones

    • Total Posts : 2467
    • Scores: 142
    • Reward points : 138230
    • Joined: 6/5/2001
    • Location: Ottawa, Ontario, Canada
    • Status: online
    RE: SCCM Reports - v_R_System vs v_GS_System Monday, July 20, 2009 2:53 PM (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
      Online Bookmarks Sharing: Share/Bookmark

      Jump to:

      Current active users

      There are 0 members and 1 guests.

      Icon Legend and Permission

      • New Messages
      • No New Messages
      • Hot Topic w/ New Messages
      • Hot Topic w/o New Messages
      • Locked w/ New Messages
      • Locked w/o New Messages
      • Read Message
      • Post New Thread
      • Reply to message
      • Post New Poll
      • Submit Vote
      • Post reward post
      • Delete my own posts
      • Delete my own threads
      • Rate post

      2000-2014 ASPPlayground.NET Forum Version 3.9