For full details see
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'