Client Management Suite

Hello,

I'm trying to join two reports together but, somehow I keep getting the data is in an unuseable state.

From this report :

DECLARE @v1_TrusteeScope nvarchar(max)
   SET @v1_TrusteeScope = N'%TrusteeScope%'
SELECT
   [vri2_Computer].[Guid] AS [_ItemGuid],
   [vri2_Computer].[Name],
   [dca3_AeX AC TCPIP].[IP Address],
   [dca5_AeX AC Primary User].[User],
   [dca4_AeX AC Identification].[OS Name],
   [dca4_AeX AC Identification].[Hardware Serial Number],
   [dca4_AeX AC Identification].[OS Version],
   [dca7_Client Task Resources].[LastRegistered],
   [dca6_HW Computer System].[Total Physical Memory (Bytes)],
   [dca4_AeX AC Identification].[Domain]
FROM
   [vRM_Computer_Item] AS [vri2_Computer]
      LEFT OUTER JOIN [Inv_AeX_AC_TCPIP] AS [dca3_AeX AC TCPIP]
         ON ([vri2_Computer].[Guid] = [dca3_AeX AC TCPIP].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_AeX_AC_Identification] AS [dca4_AeX AC Identification]
         ON ([vri2_Computer].[Guid] = [dca4_AeX AC Identification].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_AeX_AC_Primary_User] AS [dca5_AeX AC Primary User]
         ON ([vri2_Computer].[Guid] = [dca5_AeX AC Primary User].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_HW_Computer_System] AS [dca6_HW Computer System]
         ON ([vri2_Computer].[Guid] = [dca6_HW Computer System].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_Client_Task_Resources] AS [dca7_Client Task Resources]
         ON ([vri2_Computer].[Guid] = [dca7_Client Task Resources].[_ResourceGuid])
WHERE
   (
      ([vri2_Computer].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))
   )

I need to add the model and version from this report below, as the name/computer field is already present in the other report.

-----

select vItem.Name [Computer], Inv_Lenovo_Model.Model, Inv_Lenovo_Model.[Version] from Inv_Lenovo_Model

left join vItem on Inv_Lenovo_Model._ResourceGuid = vItem.Guid

First make sure Table Inv_Lenovo_Model exists..

Replace [Inv_HW_Logical_Device]  with your table name and execute.

DECLARE @v1_TrusteeScope nvarchar(max)
   SET @v1_TrusteeScope = N'%TrusteeScope%'

SELECT
   [vri2_Computer].[Guid] AS [_ItemGuid],
   [vri2_Computer].[Name],
   [dca8_Model].[Model],
   [dca3_AeX AC TCPIP].[IP Address],
   [dca5_AeX AC Primary User].[User],
   [dca4_AeX AC Identification].[OS Name],
   [dca4_AeX AC Identification].[Hardware Serial Number],
   [dca4_AeX AC Identification].[OS Version],
   [dca7_Client Task Resources].[LastRegistered],
   [dca6_HW Computer System].[Total Physical Memory (Bytes)],
   [dca4_AeX AC Identification].[Domain]
FROM
   [vRM_Computer_Item] AS [vri2_Computer]
      LEFT OUTER JOIN [Inv_AeX_AC_TCPIP] AS [dca3_AeX AC TCPIP]
         ON ([vri2_Computer].[Guid] = [dca3_AeX AC TCPIP].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_AeX_AC_Identification] AS [dca4_AeX AC Identification]
         ON ([vri2_Computer].[Guid] = [dca4_AeX AC Identification].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_AeX_AC_Primary_User] AS [dca5_AeX AC Primary User]
         ON ([vri2_Computer].[Guid] = [dca5_AeX AC Primary User].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_HW_Computer_System] AS [dca6_HW Computer System]
         ON ([vri2_Computer].[Guid] = [dca6_HW Computer System].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_Client_Task_Resources] AS [dca7_Client Task Resources]
         ON ([vri2_Computer].[Guid] = [dca7_Client Task Resources].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_HW_Logical_Device] AS [dca8_Model]
         ON ([vri2_Computer].[Guid] = [dca8_Model].[_ResourceGuid])
WHERE
   (
      ([vri2_Computer].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))
   )