Total SQL Server Systems Query

See forum post for full details: https://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/51ead03a-a43d-46df-b0ab-059d9322e432

SELECT DISTINCT 

  R.Name0, 

  R.User_Name0, 

  ARP.DisplayName0 AS [Software Name],

  ARP.Version0 AS [Installed Version], 

  IP.IP_Addresses0 AS IPAddress,

--  ARP.TimeStamp AS [Last Time Stamp], 

  ARP.InstallDate0 AS [Software Installed Date]

 FROM

  dbo.v_R_System R

  inner join dbo.v_FullCollectionMembership FCM ON FCM.ResourceID  = R.ResourceID 

  INNER JOIN dbo.v_Add_REMOVE_PROGRAMS ARP ON R.ResourceID = ARP.ResourceID 

  INNER JOIN dbo.v_RA_System_IPAddresses IP ON R.ResourceID = IP.ResourceID

 WHERE     

  (ARP.DisplayName0 LIKE 'Microsoft SQL Server 2008')

  or (ARP.DisplayName0 LIKE 'Microsoft SQL Server 2005')

  or (ARP.DisplayName0 LIKE 'Microsoft SQL Server 2000')

  or (ARP.DisplayName0 LIKE 'Microsoft SQL Server 2008 R2 (64-bit)') 

  AND (FCM.CollectionID IN ('SMS00001'))