Hope you had a Merry Christmas :)

I am trying to create a report which lists the following:

Primary User, Machine Name, Make, Model, RAM, HDD capacity, Processor Count, Processor Speed.

I have tried the Report Wizard and the results are inaccurate - in that there are multiple entries for one computers and the Model seems to list the application names. The SQL for the Altiris report is below.

Also I found a few reports people have posted on the forums which I thought I could ament to suit my needs - although im having a bit of difficulty doing that. The SQL for that report is further below.

Please can someone help me out with the Altiris report as id like to make sure I can use the inbuilt funtionality rather than rely on my poor SQL skills. :(

DECLARE @v1_TrusteeScope nvarchar(max)
   SET @v1_TrusteeScope = N'%TrusteeScope%'
DECLARE @v2_Filter nvarchar(max)
   SET @v2_Filter = N'%Filter%'
SELECT
   [vri3_Computer].[Guid] AS [_ItemGuid],
   [vri3_Computer].[Name],
   [dca6_AeX AC Primary User].[User],
   [dca10_HW Processor].[Number Of Logical Processors],
   [dca10_HW Processor].[Number Of Cores],
   [dca10_HW Processor].[Max Clock Speed (Mega-hertz)],
   [dca8_HW Physical Memory].[Capacity (Bytes)],
   [dca9_Hardware Summary].[Number of processor cores],
   [dca9_Hardware Summary].[Number of processors],
   [dca9_Hardware Summary].[Total RAM],
   [dca9_Hardware Summary].[Vendor Name],
   [dca4_HW Logical Device].[Manufacturer],
   [dca4_HW Logical Device].[Model]
FROM
   [vRM_Computer_Item] AS [vri3_Computer]
      LEFT OUTER JOIN [Inv_HW_Logical_Device] AS [dca4_HW Logical Device]
         ON ([vri3_Computer].[Guid] = [dca4_HW Logical Device].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_AeX_AC_Identification] AS [dca5_AeX AC Identification]
         ON ([vri3_Computer].[Guid] = [dca5_AeX AC Identification].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_AeX_AC_Primary_User] AS [dca6_AeX AC Primary User]
         ON ([vri3_Computer].[Guid] = [dca6_AeX AC Primary User].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_HW_Computer_System] AS [dca7_HW Computer System]
         ON ([vri3_Computer].[Guid] = [dca7_HW Computer System].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_HW_Physical_Memory] AS [dca8_HW Physical Memory]
         ON ([vri3_Computer].[Guid] = [dca8_HW Physical Memory].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_Hardware_Summary] AS [dca9_Hardware Summary]
         ON ([vri3_Computer].[Guid] = [dca9_Hardware Summary].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_HW_Processor] AS [dca10_HW Processor]
         ON ([vri3_Computer].[Guid] = [dca10_HW Processor].[_ResourceGuid])
WHERE
   (
      ([vri3_Computer].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))
   )
 

The non Altiris Wizard report:

SELECT vCom.[Name] as [Computer Name]
 ,vCom.[User]
 ,cs.[Model]
 ,cs.[Manufacturer]
 ,cs.[Identifying Number] AS [Serial Number]
 ,vCom.[OS Name] AS [Operating System]
 ,vCom.[OS Revision] AS [Service Pack]
FROM
 CollectionMembership cm
  INNER JOIN
   vComputer vCom
   ON cm.[ResourceGuid] = vCom.[Guid]
  INNER JOIN
   vCollection vColl
   ON cm.[CollectionGuid] = vColl.[Guid]
  LEFT JOIN
   vHWComputerSystem cs
   ON cs.[_ResourceGuid] = vCom.[Guid]
WHERE
 vColl.[Name] = 'Windows workstations' AND
 vCom.[IsManaged] = 1
ORDER BY
 vCom.[Name]