DECLARE @v1_ScopeCollectionGuid uniqueidentifier
   SET @v1_ScopeCollectionGuid = '%ScopeCollectionGuid%'
DECLARE @v2_TrusteeScope nvarchar(max)
   SET @v2_TrusteeScope = N'%TrusteeScope%'
DECLARE @g6_Location uniqueidentifier
   SET @g6_Location = '05de450f-39ea-4aae-8c5f-77817889c27c'
SELECT DISTINCT 
i.Name,
i.Domain,
i.[IP Address],
i.[MAC Address],
i.[System Type] [OS BIT],
sn1.Manufacturer [Manufacturer],    
sn1.[Model] [Computer Model],	    
cpu.[Max Clock Speed (Mega-hertz)] [CPU Frequency],  
cpu.[Family] [CPU Type],      
sn1.[Total Physical Memory (Bytes)] / (1024 * 1024) [Memory (MB)],  
m1.[Speed (Mega-hertz)], 
i.[OS Name],
d.[OS Version] [OS Version],    	      
CST.[Max Media Size (Kilobytes)] / (1024) [Disk Size(MB)],    
ld.[Free Space (Bytes)] [Free Space(MB)],    
sn1.[Identifying Number] [Serial Number],
[vri8_Location].[Name] AS [Location],
[vri8_Location].[State]

FROM dbo.vComputer i      
		JOIN dbo.Inv_AeX_AC_Identification d
		ON d._ResourceGuid = i.Guid
	LEFT JOIN dbo.CollectionMembership cm    
		ON cm.ResourceGuid = i.[Guid]    
	LEFT JOIN dbo.vCollection it    
		ON it.Guid = cm.CollectionGuid    
	LEFT JOIN dbo.vHWPhysicalMemory m1    
		ON  m1.[_ResourceGuid] = i.Guid       
	LEFT JOIN dbo.vHWComputerSystem sn1    
		ON  sn1.[_ResourceGuid] = i.Guid       
	LEFT JOIN dbo.Inv_HW_Processor cpu   
		ON cpu.[_ResourceGuid] = i.[Guid]
	LEFT JOIN  (SELECT SUM ([Free Space (Bytes)] / (1024 * 1024)) [Free Space (Bytes)], _ResourceGuid
		FROM dbo.vHWLogicalDisk WHERE [Logical Disk Type] = 3 GROUP BY _ResourceGuid) ld
		ON i.Guid = ld._ResourceGuid
	LEFT JOIN dbo.vOSOperatingSystem os
		ON os._ResourceGuid = i.Guid
	LEFT JOIN (SELECT SUM ([Max Media Size (Kilobytes)]) [Max Media Size (Kilobytes)],  
    _ResourceGuid FROM vHWStorage  
    WHERE [Media Type] = 29  
    GROUP BY _ResourceGuid)CST 
		ON CST._ResourceGuid = i.Guid
      LEFT JOIN Inv_AeX_AC_TCPIP t on t._ResourceGuid = i.Guid
	  
	   LEFT OUTER JOIN ([ResourceAssociation] AS [ra7_Location]
      INNER JOIN [vLocation] AS [vri8_Location]
            ON ([ra7_Location].[ChildResourceGuid] = [vri8_Location]._ResourceGuid)
               AND
               (
                  (
                     ([ra7_Location].[ResourceAssociationTypeGuid] = @g6_Location)
                  )
               ))
         ON (i.[Guid] = [ra7_Location].[ParentResourceGuid])  
WHERE
   (
      ([i].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollectionsByScope(@v2_TrusteeScope, @v1_ScopeCollectionGuid, 1))))
   )