SCCM 2012 Table has multiple records for Server IP

For full details see

http://social.technet.microsoft.com/Forums/en-US/configmanagergeneral/thread/43686ca9-3064-4533-8f94-f28c889b4511/

HS view are for History data, not current data.

RA views are discovery data views.

vSMS are “extra” views.. I don’t generally use them.

It is generally better to limit the use of NOT LIKE statements

Here is the clean up

SELECT 
    R.ResourceID AS 'ResourceID', 
    R.Netbios_Name0 AS 'Name', 
    R.AD_Site_Name0 AS 'Site', 
    NAC.IPAddress0 AS 'IP Address', 
    OS.Caption0 AS 'Operating System', 
    OS.CSDVersion0 AS 'Service Pack', 
    OS.Version0 AS 'Version', 
    R.Is_Virtual_Machine0 AS 'Virtual', 
    R.Resource_Domain_OR_Workgr0 AS 'Domain', 
    S.SystemRole0 AS 'System Type'
FROM 
    dbo.v_R_System R
    JOIN dbo.v_GS_NETWORK_ADAPTER_CONFIGURATION NAC ON R.ResourceID = NAC.ResourceID
    JOIN dbo.v_GS_OPERATING_SYSTEM OS ON R.ResourceID = OS.ResourceID
    JOIN dbo.v_GS_SYSTEM S ON R.ResourceID = S.ResourceID 
WHERE 
    NAC.IPAddress0 NOT LIKE 'fe80%' 
    AND S.SystemRole0 = 'Server'